Re: [PHP-DB] 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: [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
RE: [PHP-DB] 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. Actually, you can use any delimiter with MySQL, so long as it's in year, month, day order. DATE_FORMAT(NOW(), '%m/%d/%Y') - would return 01/22/2003 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? Many ways. This question was just asked today, actually. Simple way is: $part = explode(/,$your_date); $mysql_date = $part[2] . $part[0] . $part[1]; for MMDD format, which is also valid. Adapt to your needs. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php