check out DATE_FORMAT in the mysql manual. and acually you'll want year-month-day not year/month/day...if you're using the mysql defualt date.
DATE_FORMAT(NOW(), '%m/%d/%Y') ----- would return 01/22/2003
hth
jeff
"Diana Castillo"
<diana.castillo@nvtechnol To: [EMAIL PROTECTED]
ogies.com> cc:
Subject: [PHP-DB] inserting
dates
01/22/2003 05:19 PM
When I insert a date into Mysql it has to be in year/month/day format or
else it wont go in right.
how do I convert my date variable which is in month /day /year format into
year/month/day format?
--
Productos de salud:
http://www.nvtechnologies.com/hgh
--
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
