topic Re: How to convert a epoch timestamp String to a readable date time format? in Workato Pros Discussion Board

How to convert a epoch timestamp String to a readable date time format?

diparnab-dey1 — Sat, 14 Oct 2023 03:52:17 GMT

Hi Team,

I have a use case where I need to convert an epoch milliseconds String to a readable Date time format in Workato. I know that this is possible using the following Ruby method

timestamp1 = Time.at("1696731696612".to_i/1000.0).strftime("%Y-%m-%d %H:%M:%S")

However, seems like Workato does not support the Time.at method. Is there any other way which can be used here ? Also, is there a plan to whitelist this Ruby method in future ?

Re: How to convert a epoch timestamp String to a readable date time format?

marlon-muela — Mon, 30 Oct 2023 12:02:34 GMT

Hi @diparnab-dey1 ,

Here's a sample formula that you can use. You can use .to_time formula for converting an epoch value.

Output as a valid date:

Re: How to convert a epoch timestamp String to a readable date time format?

diparnab-dey1 — Mon, 30 Oct 2023 12:27:51 GMT

Thanks @marlon-muela This worked like a charm. One question though. The default time returned by this formula is in UTC or PDT ?

Re: How to convert a epoch timestamp String to a readable date time format?

marlon-muela — Mon, 30 Oct 2023 12:57:10 GMT

I believe that this is based on the account settings. You can use .in_timezone formula to convert the date/time into a specific timezone.