Date Time format error

[TSL]

Problems in 56284 rows. First error: Could not parse date in cell [Row0, column “Event Date Time”, row number 1]: Pattern “yyyy-MM-dd hh:mm:ss:SSS” does not match “2025-02-04 18:20:48:000”.

RowID | … | Device # | Event Date …
--------±-------±---------±---------------
Row0 | … | 21 | 2025-02-04 …
^^^^^^^^^^^^^^
Could not parse date in cell [Row0, column “Event Date Time”, row number 1]: Pattern “yyyy-MM-dd hh:mm:ss:SSS” does not match “2025-02-04 18:20:48:000”.

[takbb]

@TSL

yyyy-MM-dd hh:mm:ss:SSS

Hi @TSL and welcome to the KNIME community forum.

The error occurs because the hh in your format mask is used to represent 12 hour time format. For 24 hour time format use HH.

So if you make your format mask:
yyyy-MM-dd HH:mm:ss:SSS
it should give the required result