Re: Oracle Date query

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.

Hi Unorthodox WebSfer (whoever you are ;),

set nls_date_format=dd-mon-yyyy in your init.ora.

Miran (real name ;-)

-- 
mailto:Miran.Novak_at_mch.sni.de , SNI AG, ORACLE Database Support
(the above opinions do not reflect the opinions of SNI)