1

When exporting the oracle DB result set to CSV file using SQL developer, for the fields which are having date format, will not be saved in date format in CSV.

What I need is to have the date format for date fields in CSV as well. But when export data to CSV the date fields will get in General format. I can't change the General Format into Date in exported CSV.

VirangaMahesh
  • 325
  • 1
  • 4
  • 12

1 Answers1

0

1) change the DATEfromat in SQL Developer as required - see here

2) run the query that provides the data to be exported in csv (you sould see teh dates in the required format!)

3) in the result are per right mouse click select export and choose format csv; add other parameter as required.

Community
  • 1
  • 1
Marmite Bomber
  • 19,886
  • 4
  • 26
  • 53
  • I did the same thins and still I couldn’t get the Date as Date Format.It comes as general format. I want to it change comes as Date into excel or csv file. – VirangaMahesh Mar 08 '17 at 05:30