Re: Forms3.0 and Y2K work around.

From: Peter L <news_at_lenniep.freeserve.co.uk>
Date: Thu, 8 Apr 1999 23:25:00 +0100
Message-ID: <7ek73f$fmd$3_at_news6.svr.pol.co.uk>


Have you set the length of the :HIREDATE field to 11? If it's only 9 I think you'll be adding the correct century in the code below and stripping it off when you put the value back in the field.

John Macdonald wrote in message <370CD708.63E05DB9_at_stir.ac.uk>...
>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 Fri Apr 09 1999 - 00:25:00 CEST

Original text of this message