Re: TO_DATE in Forms 4.5: Y2K Bug

We've also run into problems with date functions under Developer/2000 1.3.2, and have been told that they will be fixed in later releases. However, if you're running 16 bit, 1.3.2 is the last release that I've seen; they're up to 1.5w under 32-bit, but it seems that those of us who are running 16-bit are SOL.

Mike Britton
Mid-States Corporate Federal Credit Union

Farah Ali wrote in message <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 Mon Oct 20 1997 - 00:00:00 CDT