Bug #11456 oracle date datatype conversion fails
Submitted: 20 Jun 2005 12:48 Modified: 2 Aug 2005 15:11
Reporter: Robert Lindgren Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S2 (Serious)
Version:1.0.7beta OS:Windows (win xp)
Assigned to: CPU Architecture:Any

[20 Jun 2005 12:48] Robert Lindgren 
Description:
A value from date column in Oracle (verion 9.2) isn't converted correctly to MySQL datetime.

For example:
2005-04-11 11:42:04 in Oracle, becomes:
2005-04-11 00:00:00 in MySQL.

The insert statement saved by the migration wiz, is also wrong, so I guess it's a bug in the tool itself.

How to repeat:
create a table in oracle with a date column, insert SYSDATE and run the wiz.
[4 Jul 2005 18:33] Jorge del Conde 
Thanks for your bug report.  I was able to  reporduce this bug using the latest Migration Toolkit version and Oracle 10g
[2 Aug 2005 15:11] Michael G. Zinner 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html