Doug, Here's an example of how to format the date:
$date = "3/2/2003"; $good_date= date("Y-m-d", strtotime($date)); ---------------------- Beverly Steiner [EMAIL PROTECTED] -----Original Message----- From: Doug Coning [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 5:38 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Confusing Date... Yes, but not too many people are familiar with enter the year first, followed by the month then the date. Is there a way within PHP to take 03/02/2002 and send it as 2003-03-02. Thanks, Doug Coning ----- Original Message ----- From: "Beverly Steiner" <[EMAIL PROTECTED]> To: "Doug Coning" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 3:35 PM Subject: 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 > [EMAIL PROTECTED] > > > -----Original Message----- > From: Doug Coning [mailto:[EMAIL PROTECTED] > Sent: Monday, March 03, 2003 5:29 PM > To: [EMAIL PROTECTED] > 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 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php