MySQL Forums
Forum List  »  Oracle

Re: Oracle Select Statement to MYSQL
Posted by: Remco Wissink
Date: November 01, 2008 11:26AM

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:

Good luck,


Options: ReplyQuote

Written By
September 12, 2008 01:23PM
September 17, 2008 05:26AM
Re: Oracle Select Statement to MYSQL
November 01, 2008 11:26AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.