Re: Oracle Date query
From: Jon Eveland <jeveland_at_nhtsa.dot.gov>
Date: 1996/12/20
Message-ID: <32BB23B5.6D1D_at_nhtsa.dot.gov>#1/1
Date: 1996/12/20
Message-ID: <32BB23B5.6D1D_at_nhtsa.dot.gov>#1/1
Unorthodox WebSfer wrote:
>
> Hi
>
> I would like to know if Oracle date datatype is able to support the year
> 2000 and beyond.
>
> As the date format is of DD-MON-YY, i think it would be impossible unless
> we are able to increase the Year to YYYY. Is there a way in Oracle to
> change the present data format to DD-MON-YYYY??
>
> TIA...8-)
>
> regards.
Actually,
you can set the date default to DD-MON-RR in the initSID.ora file, and this will comply with dates 50 years before 2000 and fifty years after. Received on Fri Dec 20 1996 - 00:00:00 CET