Sql Default Date Format

BrutusBuckeye · #1 (**permalink**) 11-27-02, 09:07

How can I change the default date format from DD-MON-YY to DD-MON-YYYY ?

andrewst · #2 (**permalink**) 11-27-02, 09:10

Quote:

Originally posted by BrutusBuckeye
How can I change the default date format from DD-MON-YY to DD-MON-YYYY ?

In what DBMS?
In Oracle:
ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY';

BrutusBuckeye · #3 (**permalink**) 11-27-02, 09:20

Quote:

Originally posted by andrewst
In what DBMS?
In Oracle:
ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY';

you are the man !