On Fri, May 22, 2009 at 12:42 PM, John Meyer <john.l.meyer@stripped> wrote:
> Janek Bogucki wrote:
>> Hi John,
>> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes
>> some information about acceptable literal forms for dates and times.
>> 'Thu May 21 03:15:28 +0000 2009' is not an acceptable literal form but
>> this is how to parse it APART from the time zone component. I could not
>> see from the documentation how to specify the time zone component so the
>> format below IGNORES the time zone.
>> mysql> create table t(d datetime);
>> mysql> insert into t(d) values(str_to_date('Thu May 21 03:15:28 +0000
>> 2009', '%a %b %e %H:%i:%s +0000 %Y'));
> BTW, how would you work that with offsets that were a different value (say
I don't think you do. You would have to get your application to parse
out the date into something that MySQL can negotiate. The only reason
this works at all in your case is because you happen to have +0000
which we can safely ignore.
- michael dykman
- All models are wrong. Some models are useful.