RE: [PHP-DB] Confusing Date...

Doug, I know it works if you send the date as yyyy-mm-dd. For example yesterday, March 2, 2003 would be 2003-03-02 ---------------------- Beverly Steiner steiner277@charter.net -----Original Message----- From: Doug Coning [mailto:lists@coning.com] Sent: Monday, March 03, 2003 5:29 PM To: php-db@lists.php.net Subject: [PHP-DB] Confusing Date... I have a MySQL column that was set to date. In my PHP page, I have a form and a field called 'Sch_StartDate'. I'm having difficultes understanding how to write to the date column in MySQL. If I send 03/04/02 for March 4, 2002, the value that gets stored in the MySQL database is 2003-04-02 for April 2nd, 2003. The field is set to to send as a date: GetSQLValueString($HTTP_POST_VARS['Sch_StartDate'], "date") So how do I send dates to MySQL so that it stores it correctly? Thank you!! Confused, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php