Export OQL to CSV

Good morning,   I’m using “Export OQL to CSV” after doing a $SELECT +' '+ $FROM +' '+ $JOINS +' '+ $WHERE, I the problem here is that some data is retrieved in the wrong way, for example the date and time. Does anyone know what I’m doing wrong?
1 answers

What does your OQL look like, what is the result and what did you expect?

If the date time is exported as a long number, you could try and cast it as string:

SELECT CAST(ObjectAlias/DateTimeAttribute AS string) AS ColumnName