Re: date format

For a permanent change

Unix: set the environment variable NLS_DATE_FORMAT to dd/mm/yyyy Windows: create a string value in HKLM\software\oracle with the same content.

Temporary changes:
alter session set nls_date_format = ...

Hth,

Sybrand Bakker, Oracle DBA

"Sandy" <daleelaNOdaSPAM_at_usa.net.invalid> wrote in message news:1140b6b8.45a67c98_at_usw-ex0109-068.remarq.com...
> hi,
>
> I would like to know how to change the default date format.
> I know it is related to somethin g to nls.
> would like to change the format dd/mm/yy to dd/mm/yyyy
>
>
> thanks
>
> sandy
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
>
Received on Fri Aug 04 2000 - 00:00:00 CEST