We are trying to export data from a table to a file and one of the column’s data type is date.
The query output in the file turns the date into epoch time.
We tried casting the field to date format but didn’t help.
Is there a way to get this done ??
Query which was run is :
echo "COPY (
SELECT CAST ( c.birth_dt AS date ) from birthday_details TO ‘/tmp/birthday_details.csv’ WITH (header=‘true’, quoted=‘false’ ); " | /mapd-core/bin/mapdql -u mapd -p HyperInteractive