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

-----Original Message-----
From: Doug Coning [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 5:29 PM
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!!



PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to