Need help withTime format Conversion

Question

Hi All,
I am trying change a date format with expression.
Input is a string value: “04/23/2021 12:00:00 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($CertActivityDate,“mm/dd/yyyy hh:mm:ss AM”).toLocaleDateTimeString( { “format”:“yyyy-MM-dd HH:mm:ss” } )
Could you please siggest.

bojanvelevski · Answer

Hi @Shrabanti,
Use the following expression:
Date.parse("04/23/2021 12:00:00 AM","MM/dd/yyyy HH:mm:ss a").toLocaleDateTimeString({"format":"yyyy-MM-dd HH:mm:ss"})
Regards,
Bojan

spirotaleski · Answer

@Shrabanti
The below post looks useful:

SnapLogic DateTime Conversion Guidelines Designing Pipelines

The SnapLogic Elastic Integration Platform native DATETIME data type is time zone-aware. For service endpoints that do not expose data types that are not time zone-aware, the SnapLogic Expression Language can be used to easily convert to supported 3rd party date, datetime, time, and timestamp data types. 
The matrix below provides sample conversions between the SnapLogic DATETIME variable, $snapDateTime, and several known 3rd party data types normalized to the US/Pacific time zone. 
NOTE: For 3r…

Regards,
Spiro Taleski

shrabanti · Answer

@bojanvelevski Thank you it worked.
Could you please also point me where I can see all different time formats.
Thanks &amp; Regards,
Shrabanti

bojanvelevski · Answer

You can refer to these links for more information:
SimpleDateFormat
ParsingDate

Forum Discussion

Need help withTime format Conversion

4 Replies

Recent Discussions

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

Unable to write sldb file to file system