How to set/change date format?(m53)

How to change the default date format in Oracle8 from DD-MM-YY to DD-MM-YYYY??

Ans:

If you want to change the date format for the entire database then goto the initora.ora file a look for NLS_DateFormat.

Or you can change the date format for a session.  Use Alter Session command for that.
            ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY';
 

Hosted by www.Geocities.ws

1