Re: Can't Set Default Date Format on Startup!!!!

Gene Hubert wrote:
>
> I'm running oracle 7.2 on Windows NT with OS/2 clients. I can't
> seem to set the default date format. I've put
> nls_date_format = 'mm/dd/yy'
> in my parameter file but it seems to have no effect. The system
> still insists on dates as per 01-AUG-96 even though the result
> from a show parameters command is
> nls_date_format string 'mm/dd/yy'

  If you have set NLS_TERRITORY for your session, you need to suppress it because it will override your date format.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841