Re: NLS_DATE_FORMAT - Y2K Question

From: Patrick Suppes <psuppes_at_lucent.com>
Date: Fri, 23 Apr 1999 09:59:42 -0600
Message-ID: <372098EE.C0F631A0@lucent.com>

One caveat to watch out for is applications written or used by your customer set, outside of your supported set of applications. They may have code that parses the incoming text files for an application you have never heard about. You may not know about their process, but you will probably be guilty if it suddenly "stops working".

Another place to watch out for is in report writers. If the dates suddenly
expand by two characters, you may encounter some formatting problems.

Good luck,

Patrick Suppes

Frank Siegel wrote:

> Currently the default display date for NLS_DATE_FORMAT
> is DD-MON-YY. Assuming that all the PL/SQL and DML code
> always formats a 4-digit year, is there anything to "watch out" for
> when we change the NLS_DATE_FORMAT to DD-MON-YYYY?
>
> We are using Oracle 7.3 and soon going to Oracle 8.
>
> Thanks in advance for any help
> Frank S. Kaiser, New Hampshire
Received on Fri Apr 23 1999 - 10:59:42 CDT