How can I insert a Date with milliseconds in MySQL?
I want to Export Data from a MS SQL table in a MySQL table. Everything works fine besides the dateformat.
In MS SQL datetime is stored with milliseconds. In my MySQL table I changed the type from datetime to datetime(3), but the milliseconds are ignored on insert.
Inserted Date in MySQL: