Default Date Format in CSV file

Question

I'm creating a CSV file from my application, using oracle. When I open the csv file created, the columns which include dates are formatted in a special format such as dd-mmm-yy and not dd/mm/yyyy which is what I was expecting.

What can be the reason for that and what can I do to prevent it from happening?

just a hunch: could it have to do with the locale setting of the machine? — codeling
– codeling, Commented Dec 27, 2011 at 10:22

Rob van Laarhoven · Accepted Answer · 2011-12-27 13:47:32Z

1

The reason is the default date format in NLS_DATE_FORMAT. It can be set in a lot of places: sql session (in a logon trigger), os variable, registry, pfile. Or it can be derived from settings like NLS_TERRITORY wich can be explicitly set or derived from the locale setting on the client.

SQL>alter session set NLS_DATE_FORMAT='DD/MM/YYYY';
SQL>[select csv statements;]

Probably will do the trick

answered Dec 27, 2011 at 13:47

Rob van Laarhoven

8,9552 gold badges33 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

baliman · Accepted Answer · 2011-12-27 10:22:43Z

0

use TO_CHAR(date, 'format') function on your column where the format is dd/mm/yyyyy

answered Dec 27, 2011 at 10:22

baliman

6202 gold badges10 silver badges31 bronze badges

Collectives™ on Stack Overflow

Default Date Format in CSV file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related