Time format Conversion not working

Question

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 incoming date format but unable find proper format for input date.
Date.parse($OrderDetailUpdateDate,“dd-MMM-yyyy’ 'HH:mm:ss.SSSXXX AM”).toLocaleDateTimeString({“format”:“yyyy-MM-dd HH:mm:ss”})
Could you please siggest.

koryknick · Answer

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

shrabanti · Answer

Thank you it worked…

Forum Discussion

Time format Conversion not working

2 Replies

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found