SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Reset the Default date format

Muthukumar SJun 14 2006 — edited Jun 15 2006

Hi,
We have our database with the default date format as 'DD-MON-YY' and we need that to me updated as 'YYYY-MM-DD'.

Tried using Alter session set nls_date_format = 'YYYY-MM-DD'
But this is active only to that session - while i tried using ALTER SYSTEM instead of SESSION got ORA-02096 error.

How to overcome this.

Thanks,
S.Muthukumar.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2006

Added on Jun 14 2006

3 comments

407 views