OQL is generating UNIX Time for DateTime data type field

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.
1 answers

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