Question
Wells Fargo
IN
Last activity: 8 Oct 2021 15:06 EDT
How to convert Unix timestamp to GMT formart
Hi All,
I have requirement that i get Unix TimeStamp from external system and i should convert it to GMT format how does pxCreateDateTime has in clipboard. Can any one know about this? Any OOTB function avalable. Please help me.
Ex: "createDtTime": 1631023948012,
TIA.
Regards,
Vinay LAkka
Accepted Solution
Updated: 8 Oct 2021 15:06 EDT
Blue Rose Technologies
DE
I am not aware of any OOTB way to directly convert from unix time stamp. If you don't find a better way you can convert as below,
@addToDate("19700101T000000.000 GMT",@toInt(Param.UnixTime)/86400,(@toInt(Param.UnixTime)%(86400))/3600,((@toInt(Param.UnixTime)%(86400))%(3600))/60,((@toInt(Param.UnixTime)%(86400))%(3600))%(60))
In the below screenshot from expression builder, Param.UnixTime is the time you mentioned above in seconds. Your time is in milliseconds. I removed last three digits to convert it to seconds.
Please see below screenshot for online conversion of same unix time to GMT date. I tried with different date time values and its working.
Wells Fargo
IN
@ShyjuValappil Thank you above fix is working in single step. I will try to convert the same logic through function.
Updated: 17 Sep 2021 15:19 EDT
Rulesware
PE
@VinayLakka125 Create a new function (ex. UnixTimestampToPegaDateTime) with 2 parameters: timeUnix and timeZone with the following code. This will return the Pega date time format.
// Convert the string "timeUnix" to Date
Long d = Long.parseLong(timeUnix, 10);
Date d1 = new Date(d);
// Format to fit in the appropiate PEGA type
// timeZone can be "GMT-5"
return PRDateFormat.format(null, timeZone, PRDateFormat.PEGARULES_INTERNAL_DATETIME, d1);
If you want to get DATE instead of DATETIME use PRDateFormat.PEGARULES_INTERNAL_DATE.