Re: Oracle Select Statement to MYSQL

[Remco Wissink]

Hi Angel,

I did have the same issue a couple of weeks ago. I wanted to store ORACLE table data into my MYSQL database.

Try instead of the common TO_DATE function STR_TO_DATE() function.

Someting like: STR_TO_DATE('04/01/2009 12:00:00 AM', '%m/%d/%Y %h:%i:%s %p')

Look for the date and time formats at the funtion DATE_FORMAT(date,format) in the reference manual:

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date

Good luck,

Scarecrow