Confusing Date...
| From: | Doug Coning | Date: | Mon, 03 Mar 2003 22:28:57 +0000 |
| Subject: | Confusing Date... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26071@lists.php.net to get a copy of this message | ||
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