Re: inserting dates

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: php-db@lists.php.net 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