Confusing Date...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux