List:General Discussion« Previous MessageNext Message »
From:Donovan Brooke Date:January 8 2012 8:37pm
Subject:Re: Date and Time
View as plain text  
Peter Brawley wrote:
> 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




-- 
D Brooke
Thread
Date and TimeDonovan Brooke8 Jan
  • Re: Date and TimeAndrew Moore8 Jan
    • Re: Date and TimeGovinda8 Jan
  • Re: Date and TimePeter Brawley8 Jan
    • Re: Date and TimeDonovan Brooke8 Jan
  • Re: Date and TimePaul DuBois9 Jan
    • Re: Date and TimeGovinda9 Jan