Question on NLS_DATE

From: Sean <dolans_at_my-deja.com>
Date: Thu, 06 Apr 2000 16:31:07 GMT
Message-ID: <8cie4c$3o8$1@nnrp1.deja.com>

Oracle 8i. When I do a select to_char(sysdate) from dual, I get '06- APR-00' I would like the year to be 2000.

I can do an alter session, set nls_date_format = 'DD-MON-YYYY' and ok. But I want this to be consistent for every session, stored proc, package, etc.

I have gone into my init.ora and set the nls_date_format and restarted the instance. I can even use svrmgrl and do a show parameters NLS and see that the format is correct.

Why would the date still be returning in 00 format vs 2000?

Thanks,
Sean

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 06 2000 - 11:31:07 CDT

Question on NLS_DATE_FORMAT