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 failing.
Looks like it's not in version 4.0.2?
Minh:
Your options are:
* upgrade to 4.1
* parse and convert the date in your applications
* use an ugly combination of SUBSTRING() and CASE to parse out the date
* write a UDF implementing STR_TO_DATE()
* backport STR_TO_DATE() to 4.0
--
Sasha Pachev
AskSasha Linux Consulting
http://www.asksasha.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
