Re: dd/mm/yy - fixed default?

Marc Parkinson (marcpark_at_uswest.net) wrote:
: 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.

The best bet is to change to a suitable default so that two digit years will work.

People have always used two digit years, long before computers were around, and they will continue to use them after the year 2000.

You can bet that in the year 2002 people will stop using four digit years. They will all know exactly what year is meant when they see 02. The recent four digit verbosity will quickly revert to the shortened form once again. (And you should of course convert all such dates into their true values internally.)

my $.02

malcolm

: 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 Mon Dec 20 1999 - 15:57:13 CST