Hello, On 05/11/2002 08:42 AM, 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 ??
ISO 9601: YYYY-MM-DD HH:MM:SS This is the format that was adopted by Metabase PHP database abstraction package. Metabase is meant to provide true portability to database applications, so this format was choose because it is the one that most databases support. http://www.phpclasses.org/metabase Even those that support multiple format support this one even if it requires that you set some configuration option before you retrieve date/time fields values from the database, so no format conversion is necessary to assure that Metabase based applications do not need to handle in the application eventual differences of date/time formats that databases use. -- Regards, Manuel Lemos -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php