Assume the following table: create mytable ( mydate date ); Assume the following inserts: INSERT INTO mytable VALUES( "2003-02-20"); INSERT INTO mytable VALUES( "2004-12-25"); INSERT INTO mytable VALUES( "1999-01-01");
The following will order this table, assuming precedence of year->month->day, and print in Euro format: SELECT DATE_FORMAT(mydate,"%d/%m/%Y") FROM mytable ORDER BY mydate; The following will order this table, assuming precedence of day->month->year, and print in Euro format: SELECT DATE_FORMAT(mydate,"%d/%m/%Y") AS edate FROM mytable ORDER BY edate; With basic PHP, you can format the Euro date input into the script into the YYYY-MM-DD requied for insertion into the database. -----Original Message----- From: ax [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 6:11 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] date how would i enter european format date into mysql (dd/mm/yyyy) ... and how would i make the query sort by date if i am using this format ?? ax -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
