On 1/8/2012 2:21 PM, Donovan Brooke wrote:
Hello, I'm doing an insert into with date and time type fields.
I was reading:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-literals.html
My question is: is the format always 'year month day'?.. or can we
save dates in 'month day year' as well?
As the manual says, MySQL wants yyyy-mm-dd. Use Str_To_Date() to format
date strings to the format MySQL uses.
PB
-----
Thanks,
Donovan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
