Date format in NodeJS is different to PHP

[MH2ag]

Hi @patrick, I need just the same output as in PHP (like in my first post). The reason is that I need it for a condition to work correctly.

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]