How to Epoch to Date conversion in EMS using SQL or PQL?

Hi @mallik.koruk11,

• In PQL, you can use ADD_SECONDS (celonis.com) and use timestamp 0 as base:
  • ADD_SECONDS ( {t 0 } , "Table1"."Seconds" )
• In VERTICA SQL, you can use TO_TIMESTAMP (vertica.com) to do the same without any other input arguments.

I hope this answers your question.

Cheers,

Jan-peter

It is working in PQL editor, but it is converting in the action flows configuration itself.

Thank you very much :)

Hi @mallik.koruk11,

You can try to things to solve this:

• Specify your input explicitly as described here: https://docs.celonis.com/en/action-flow-inputs#UUID-b07391c5-21f7-cd4e-ddcb-b29617dd1636. In the current UI this is placed in top (see screenshot below)
• Use the same method by adding the seconds to Epoch in Action Flows: https://docs.celonis.com/en/date---time-functions.html#UUID-8c999d7c-90b6-d4d4-0f6d-feeddeb89802_id_setsecond-date-number

Its helps, thank you very much :)