Seconds in string to date&time node

[pjacob]

Hi
I want to replace string to date&time format but unfortunately I have dates like “2020-05-25 01:02:13” and “2020-05-25 01:02” is there any option to add zero at the end to have “2020-05-25 01:02”:00 ?

[JustinC]

In String to DateTime node seconds and milliseconds by default are in square brackets. That means they are optional and format cuts what is optional. At the same time if brackets are not specified it could be possible to keep zeros.
You need to remove :ss square brackets [ ] .
This will indicate that :ss is not an optional but necessary part.

[ipazin]

Hi there @pjacob,

if I got you right you should use square brackets around :ss to indicate this part is optional while converting to Date&Time format.

yyyy-MM-dd HH:mm[:ss]

Br,
Ivan