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
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.