Re: Setting date format in Personal Oracle 7

Set the NLS_DATE_FORMAT parameter in init<sid>.ora file

nls_date_format = yyyymmdd;

You can also change this at the session level in sqlplus using the

   alter session set nls_date_format = 'YYYYMMDD'; command.

Hope this helps Received on Sun Jul 27 1997 - 00:00:00 CDT