Date Time format error

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”.

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

3 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.