Formatting date values when exporting to .csv files

Toad Data Point
1

I know that it is possible to change the date format when sending the output of a query to a csv file, I did it once before, but now am stuck and cannot figure out what I did.

I would like the date format to be DD/MM/YYYY. How/where do I specify this?

Thanks in advance!
Alan

2

Ok, here is the solution.

select
to_char(trunc(P2K_HR_EMPLOYMENTS.HIRE_DATE)) AS “HIRE DATE”

along with Tools->Options ->Environment -> Grid Data Type Formatting set to custom dd/MM/yy
was able to get what I needed.

Alan