From: Peter Brawley
Date: January 8 2012 8:35pm
Subject: Re: Date and Time
List-Archive: http://lists.mysql.com/mysql/226571
Message-Id: <4F09FE03.4070106@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
>
>