Re: Oracle Date query
Date: 1996/12/20
Message-ID: <32BAB0BA.5ED3_at_telesph.com>#1/1
The present date format is actually much more than DD-MON-YY.
It includes time and more importantly century.
The default display format is DD-MON-YY, that's all.
What Miran suggested will work to change your default -
but all the info is in there. that's an important
difference, i think. try:
select to_char(date_col,'dd-mon-yyyy') from table1;
and you'll see the century you have in there.
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.
Received on Fri Dec 20 1996 - 00:00:00 CET