Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DATE FORMAT
Yulia,
In the INIT.ORA file, use the following parameter:
nls_date_format = MM/DD/YYYY
--
Regards,
Greg Lechkun
gpl :-)
Yulia wrote:
> 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 Fri Feb 11 2000 - 07:23:32 CST
![]() |
![]() |