Re: TO_DATE in Forms 4.5: Y2K Bug

I think this is a problem in PL/SQL 1 which is in forms 4.5, but works OK in PL/SQL 2 which is in the database and forms 5.0.

A possible workaround might be to write a PL/SQL 2 function stored in the database
that does the conversion for you, then call that from forms:

vdate := my_to_dat('15-OCT-97','DD-MON-RR');

-Mike Madland

Farah Ali <ALIF_at_erols.com> wrote in article <344ABF73.6F84_at_erols.com>...
> In Forms 4.5 ( for Developer /2000, v1.3.2 ), the TO_DATE function
> does not convert DD-MON-RR correctly. For example,
>
> vdate := TO_DATE( :blk.date_field, 'DD-MON-RR' );
>
> if :blk.date_field is 01-JAN-2000
> then vdate becomes 01-JAN-1900.
>
> A work-around for this is to do a 'select to_date() from dual'.
>
> A forms basetable field having the 'RR' format gets updated correctly,
> but a conversion with TO_DATE is incorrect.
>
> Does anyone know of a bug fix for this??
>
> Thanks in advance,
> Farah [ Please e-mail at alif1_at_tksrv16.usps.gov ]
>
Received on Tue Oct 21 1997 - 00:00:00 CDT