TO_DATE in Forms 4.5: Y2K Bug

From: Farah Ali <ALIF_at_erols.com>
Date: 1997/10/19
Message-ID: <344ABF73.6F84@erols.com>#1/1

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 Sun Oct 19 1997 - 00:00:00 CDT