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

Home -> Community -> Usenet -> c.d.o.misc -> NLS_DATE_FORMAT - Y2K Question

NLS_DATE_FORMAT - Y2K Question

From: Frank Siegel <NorthernSnow_at_worldnet.att.net>
Date: Fri, 23 Apr 1999 11:09:12 -0400
Message-ID: <7fq2gj$rst$1@bgtnsc02.worldnet.att.net>


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:09:12 CDT

Original text of this message

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