Time format Conversion not working
Hi All,
I am trying change a data format with expression.
Input is a string value: “9-JUN-21 10.06.39.000000 AM”
Output should be ‘yyyy-MM-dd HH:mm:ss’ format
I am trying data parse the inco...
Forum Discussion
Hi @Shrabanti - I think this is what you’re looking for:
Date.parse(“9-JUN-21 10.06.39.000000 AM”, “dd-MMM-YY hh.mm.ss.SSSSSS aa” ).toLocaleDateTimeString( { “format” : “yyyy-MM-dd HH:mm:ss” } )
SnapLogic date parsing using Joda formatting. Here is a good reference on the format strings:
https://www.joda.org/joda-time/key_format.html
