Re: date()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux