Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: DATE FORMAT

Re: DATE FORMAT

From: <italo.bozzi_at_news>
Date: Sat, 12 Feb 2000 08:54:31 -0400
Message-ID: <883hpt$qoo13@nova.entelchile.net>


Yulia,

What you can do, to setup permanently the date format, is adding the next line to the "init.ora" file:

NLS_DATE_FORMAT = "DD-MON-YYYY" Note that you can choose the correct format for your instance.

I hope that this could help you.

Best regards,

Italo Bozzi
Oracle DBA

"Yulia" <yuliam_at_catuity.com> escribió en el mensaje news:38a396f6_at_news1.idx.com.au...
> How can I change the default (which is 'DD-MON-YY')
> system oracle date format to another one not for the session
> duration but permanently.
>
> Thankyou an advance
>
>
Received on Sat Feb 12 2000 - 06:54:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US