OQL is generating UNIX Time for DateTime data type field

1
Hi Reader   I am using mendix provided Java Action ExportOQLToCSV for creating the OQL response as a CSV, however for the DateTime field type, it is generating time in microseconds, but needed in format ‘dd-mm-yyyy’. I have tried using FROM_UNIXTIME but it didnt worked. What are other alternatives to achieve the same.
asked
1 answers
2

You can use CAST, like

CAST(youralias/datetimeattribute AS string) AS columntitle

 

This will return date and time including milliseconds like this:

2022-03-23 15:45:06.362

answered