Re: date()
| From: | Jason Wong | Date: | Mon, 18 Nov 2002 19:31:56 +0000 |
| Subject: | Re: date() | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23454@lists.php.net to get a copy of this message | ||
On Tuesday 19 November 2002 03:26, Aaron Wolski wrote:
> Hmm.. I would get it into a unix_timestamp (unless someone can suggest a
> reasoning for now doing so).
It really depends on where you want to manipulate the dates. If mostly from
within MySQL then store with DATE, DATETIME & TIMESTAMP, if within PHP then
use UNIX_TIMESTAMP.
> Select unix_timestamp(storedDate) as date FROM SomeTable where blah
> blah"
>
> Should work like that?
Yes, something like that.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
I didn't order any WOO-WOO ... Maybe a YUBBA ... But no WOO-WOO!
*/