[Fwd: Forms3.0 and Y2K work around.]

John Macdonald wrote:

> 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 of datatype DATETIME but not if it is
> DATE, can
> anyone tell me why?
>
> Many Thanks.
Received on Fri Apr 09 1999 - 11:10:33 CDT