Re: Best way for date/time

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