Date form when exporting to cvs file

Toad Data Point
1

Hi

I wonder if anyone has ideas on this.
I am running a SQl script through the Data Export Wizard which is being exported to a CSV file.
Part of the data exported is a date.
In my SQL script I have the line
to_date(“AdjustmentDate”,‘dd-mm-rrrr’)“AdjustmentDate” to give me my date data, however when this gets exported to the CSV file the date is turned into the format
yyyy-mm-dd hh:mm:ss

How do I get it to export to the CSV file in origianl format.

This is driving me mad, so any help would be appricated.

Thanks
Dave

2

Use “to_char” instead of “to_date”.

Debbie

3

Thanks Debbie