Insert Date with milliseconds in a datetime(3) column MySQL

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.

JSON:

{"ErstelltAm":"2020-05-22 09:06:28.580"}

Inserted Date in MySQL:

image

Community Page
Last updated: