Re: Need to set rmy date format to 'DD/MM/YYYY'

From: "Christophe" <clucet_at_perinfo.com> >> I need to set my date format on a database with Oracle 7.3.3.0.0. I tried with the command ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY'; but when i want to insert a date with this format, an error occurs since the
'DD/MM/YY' format is needed. I wonder if the alter session effects end with a
commit/rollback... <<<<

No, the alter session command is in effect until changed or the session is terminated. Did your insert statement have the date in the new defalut format
'dd/mm/yyyy' format or 'dd-mon-yy'? You probably need to post the sql.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Mon Sep 14 1998 - 18:00:45 CDT