|
Oracle MySQLImportieren von Oracle dumps in Mysql DB.
Oracle
|
Mysql
|
TO_DATE
|
STR_TO_DATE
|
MM/DD/YYYY HH24:MI:SS | %m/%d/%Y %H:%i:%s
|
z.B.
select TO_DATE('05/20/2009 15:14:04', 'MM/DD/YYYY HH24:MI:SS');
ändern in
select STR_TO_DATE('05/20/2009 15:14:04', '%m/%d/%Y %H:%i:%s'); | |
|
|