Question

OQL to CSV Datetime epoch value

0

Hi, What is the correct select notation to output a datetime field to a notation like dd-MM-yyyy HH:mm:ss (for example). I noticed the OQL to CSV action outputs to Epoch Thanks!

asked 2021-09-09

Ruud Fleskens

1 answers

Martin Koelewijn · Accepted Answer · 2021-09-09

You can do SELECT CAST(blah/DateTimeAttribute AS string) AS Header, see also the documentation for cast