Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: New century - URGENT

Re: New century - URGENT

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/09/19
Message-ID: <34234825.6D16@postoffice.worldnet.att.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US