lol ! no thats not what I meant ! what's best to put into MySQL datetime from MySQL now() or from php date !
Regarding the format - its a german site so not expecting many yanks there ! :-)) > On Saturday 11 May 2002 19:42, John Fishworld wrote: > > Due to the large variety of MySQL and PHP date time formats > > I'd like to have a couple of opinions from people out there ! > > > > Building a job database - and one of my fields is of course date time ! > > Which I want to be able to use latter in show all from last week, last > > month etc ! > > > > Also I want to show the date later in the european from > > ie day/month/year ! > > > > > > What is the best format to use ?? > > IMHO the best is YYYY/MM/DD, should (hopefully) be obvious to anyone. > > Using DD/MM/YYYY would confuse the poor yanks :) > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > The PINK SOCKS were ORIGINALLY from 1952!! But they went to MARS > around 1953!! > */ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php