You can retrieve dates in the next century using the 'RR' date format.
Hope this helps.
Michael Serbanescu
Angela Maria dos Santos wrote:
>
> We have various programs (PL/SQL, SQL, FORMS/3 and REPORT/1), that we
> must to convert to year 2000.
> Same tests were done, but the results were not good.
>
> Anybody knows how we can work with the function to_date, that dates are
> stored with 2 positions for year, and convert for 4 positions.
>
> Please, send us a answer.......
>
> Address: amsantos_at_intra.singer.com.br
Received on Fri Sep 19 1997 - 00:00:00 CDT