Forms3.0 and Y2K work around.

From: John Macdonald <john.macdonald_at_stir.ac.uk>
Date: Thu, 08 Apr 1999 17:19:20 +0100
Message-ID: <370CD708.63E05DB9_at_stir.ac.uk>

[Quoted] Oracle offer a suggested work around for FORMS3 that will generate Y2k dates for dates entered with only a two digit year specified i.e.

declare
  TMPDATE CHAR(9);
begin
  TMPDATE := TO_CHAR(:HIREDATE,'DD-MON-YY');   SELECT TO_DATE(TMPDATE,'DD-MON-RR')
  INTO :HIREDATE
  FROM DUAL; end;

This seems to work if HIREDATE is DATETIME but not if it is DATE, can anyone tell me why?

Many Thanks. Received on Thu Apr 08 1999 - 18:19:20 CEST