Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Y2K and RR for the NLS_DATE_FORMAT

Re: Y2K and RR for the NLS_DATE_FORMAT

From: Steve Halko <steveh_at_redshift.com>
Date: Sun, 12 Dec 1999 00:32:16 -0800
Message-ID: <s56nd1lh5340@corp.supernews.com>


Depends on what ranges of years you need to handle. If all date inputs and outputs are in in the range from 1950-2049, then RR should work fine. In our applications, we deal with years outside that range, so RR would not work for us - we moved to YYYY in the init.ora, but also changed all our SQL scripts and PL/SQL code to never depend on the Oracle default.

"Joe D" <joed_at_icoms.com> wrote in message news:384fd478$1_at_News.Destek.net... ...
>
> Any thoughts on possible impact to changing from YY to RR?
>
Received on Sun Dec 12 1999 - 02:32:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US