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?
asked
Helga Afonso
1 answers
0
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