Need help withTime format Conversion

[Shrabanti]

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]

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

[Shrabanti]

@bojanvelevski Thank you it worked.
Could you please also point me where I can see all different time formats.

Thanks & Regards,
Shrabanti

[bojanvelevski]

You can refer to these links for more information:

SimpleDateFormat

ParsingDate

[SpiroTaleski]

@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