Toad World® Forums

Date form when exporting to cvs file


#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