Re: Date Conversion on Mysql 4.0.2

2005-01-28 Thread Sasha Pachev
Minh La wrote: Hi, Can some help me with a date conversion problme that I am having. I have a date data in the following format: 'Month Days Year Hour:Minute AM/PM' Example: 'Aug 21, 2004 2:00 PM' So far the hours that I have spent have been in vain. I tried using str_to_date, but it keeps failin

Re: Date Conversion on Mysql 4.0.2

2005-01-28 Thread Hassan Schroeder
Minh La wrote: So far the hours that I have spent have been in vain. Next time a couple of minutes with the Fine Manual instead? :-) I tried using str_to_date, but it keeps failing. Looks like it's not in version 4.0.2? Quoting the FM: "STR_TO_DATE() is available as of MySQL 4.1.1." FWIW, -- Ha

Date Conversion on Mysql 4.0.2

2005-01-28 Thread Minh La
Hi, Can some help me with a date conversion problme that I am having. I have a date data in the following format: 'Month Days Year Hour:Minute AM/PM' Example: 'Aug 21, 2004 2:00 PM' So far the hours that I have spent have been in vain. I tried using str_to_date, but it keeps failing. Looks lik