Bug #89199 WorkBench messes up the datetime data value and gives an incorrect value
Submitted: 12 Jan 2018 1:04 Modified: 16 Jan 2018 23:10
Reporter: Shawnik Raghav Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S1 (Critical)
Version:6.3 CE OS:Windows
Assigned to: CPU Architecture:Any
Tags: datetime, incorrect, migration, MySQL, nofix, Urgent, value, workbench

[12 Jan 2018 1:04] Shawnik Raghav 
Description:
I am trying to migrate my entire database from sql server 2014 express to mysql 5.7.19 but for some reason Workbench is not able to understand the datetime values and messes it up.

For Eg:
THE ACTUAL VALUE: 2017-11-26 13:00:09.713
VALUE DURING MIGRATION: 0026-00-17 1:00:09:00000

I don't know why this is doing but my very urgent work is pending because of this.

Any urgent help will be really appreciated.

Thank You

How to repeat:
Everytime I do this, it is being repeated.
[16 Jan 2018 22:06] Shawnik Raghav 
UPDATE:
This issue is fixed now. I was checking a checkbox of use local time which was messing up the datetime format. I have unchecked it and it works fine now.
[16 Jan 2018 23:10] MySQL Verification Team 
Thank you for the feedback.