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