How to convert string(format YYYYMMDDHHMMSS) into the timestamp(date) value using either SQL or PQL? | Community

How to convert string(format YYYYMMDDHHMMSS) into the timestamp(date) value using either SQL or PQL?

Page 1 / 1

Hey Deepak,

In Celonis you can use the TO_DATE function (https://docs.celonis.com/en/to_date.html).

For the current time this would result in:

TO_DATE ( '20220910092700', FORMAT ( '%Y%m%d%H%M%S' ) )

This should work.

Maurits

Getting syntax error

Output

Execution error: Incorrect syntax near '20220910092700'.

Hey Anad,

Above synthax works in the cloud environment. Could you provide the full formula you are using?

Synthax and output

Reply