mysql date format is YYYY-MM-DD including the hyphens) I usually use substr() to convert it from a user's entry to the format reqd for the database
hth Dave -----Original Message----- From: ax [mailto:[EMAIL PROTECTED]] Sent: 18 October 2001 10:47 To: [EMAIL PROTECTED] Subject: [PHP-DB] date if i unput the values 10/10/2001 into mysql database, would mysql or php recognize that as a date?? i am a bit confused. i inserted few dates in the above format and asked mysql to list them by date and it does not seem to work. any suggestions?? please :) 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]