From: janet <janet@telesph.com>
Subject: Re: Oracle Date query
Date: 1996/12/20
Message-ID: <32BAB0BA.5ED3@telesph.com>#1/1
references: <59d7fk$5no@nuscc.nus.sg>
to: Unorthodox WebSfer <chewtsun@iscs.nus.sg>
content-type: text/plain; charset=us-ascii
organization: Happy Land Sanitarium
mime-version: 1.0
newsgroups: comp.databases.oracle.tools
x-mailer: Mozilla 2.01Gold (Win95; I)



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.