Getting the following error when trying to convert date time to a specific string format:
Cannot coerce String (2023-02-07 08:23:00.167000) to LocalDateTime, caused by: Text ‘2023-02-07 08:23:00.167000’ could not be parsed, unparsed text found at index 25
6| crtDate: dtTime as LocalDateTime {format : "yyyy-MM-dd HH:mm:ss.SSSSS"} as String {format:"yyyy-MM-dd’T’HH:mm:ss"}
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Trace:
at main::main (line: 6, column: 12)
%dw 2.0
var dtTime = '2023-02-07 08:23:00.167000'
output application/json
---
{
crtDate: dtTime as LocalDateTime {format : "yyyy-MM-dd HH:mm:ss.SSSSS"} as String {format:"yyyy-MM-dd'T'HH:mm:ss"}
}
Expected: 2023-02-07T08:23:00
>Solution :
The format string has 5 digits for the milliseconds however the input has 6 characters. Adding another S fixes it.
Example:
"yyyy-MM-dd HH:mm:ss.SSSSSS"