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
steiner277@charter.net
-----Original Message-----
From: Doug Coning [mailto:lists@coning.com]
Sent: Monday, March 03, 2003 5:38 PM
To: steiner277@charter.net
Subject: Re: 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" <steiner277@charter.net>
To: "Doug Coning" <lists@coning.com>
Cc: <php-db@lists.php.net>
Sent: Monday, March 03, 2003 3:35 PM
Subject: RE: 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: 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
