yyyy-mm-dd in DATE format
you can pull it back out however you like with the DATE_FORMAT command
"SELECT sometext,DATE_FORMAT(somedate,'%m/%d/%Y') AS date FROM tablename"
then you have two variables:
sometext and date
see documentation on www.mysql.com for more info on DATE_FORMAT
-----Original Message-----
From: Rosen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 10:28 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Date field
Hi,
Can someone tell me how do stote date field in MySQL DB ?
Thanks,
Rosen M.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
