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: Gregory P Lechkun <lechkung_at_dteenergy.com>
Date: Fri, 11 Feb 2000 08:23:32 -0500
Message-ID: <38A40D54.75350846@dteenergy.com>


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

Original text of this message

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