Re: dd/mm/yy - fixed default?

From: Marc Parkinson <marcpark_at_uswest.net>
Date: Thu, 16 Dec 1999 18:34:06 -0700
Message-ID: <3859930E.2D7615A0@uswest.net>

If you want the script to still only use 2 digit year (This is a bad idea) then in the init.ora file change the NLS_DATE_FORMAT='DD-MON-RR' the RR will set 00 - 49 as 2000 not 1900. Your best bet is still to change the format
to 'DD-MON-YYYY', or something along those lines.

Marc G. Parkinson

james wigley wrote:

> Is it inevitable that and SQL scripts which queries a date field in an
> Oracle database will return with the format dd/mm/yy, unless the to_char(,)
> function is used - or is there a global default or setting that will prevent
> me from having to update a load of old scripts?
Received on Thu Dec 16 1999 - 19:34:06 CST