Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DATE FORMAT
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
![]() |
![]() |