From daemon Thu Jan 25 12:13:29 1996 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA08288; Thu, 25 Jan 1996 12:13:22 -0500 Message-Id: <9601251713.AA08288@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 4330; Thu, 25 Jan 96 09:01:22 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 5564; Thu, 25 Jan 1996 08:51:54 -0500 Date: Thu, 25 Jan 1996 08:51:54 -0500 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: Malcolm Turner Subject: Oracle Date Formats X-To: ORACLE-L@ccvm.sunysb.edu To: Multiple recipients of list ORACLE-L X-Orig-Date: Wed, 24 Jan 1996 23:22:13 +0100 Dear All Database : 7.1.6 Forms : 4.5.6 We are having difficulty with dates around the year 2000. We set the NLS_DATE_FORMAT in the init.ora to DD-MON-RR which is supposed to round the year to the nearest 50 years i.e. an entry of '01-JAN-01' should be stored as 1st Jan 2001, with '31-DEC-99' stored as 31st Dec 1999. This appears to have no effect in either SQL*Plus or Forms. In SQL, an "ALTER SESSION" command works, and Forms can be forced to work by putting a format mask of DD-MON-RR on the date fields, but I understood the parameter in the init.ora file is supposed to avoid the need for the extra coding. Has anyone any suggestions to avoid re-visiting all the forms in the system, please. TYIA Malcolm Turner Oracle Developer Wellington Computer Systems, Belfast