Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: R: Specifying NLS_DATE_FORMAT
I had the same problem and even with restarting the computer it didn't
change anything. If you find the answer let me know.
bye
Patcyr
In article <7vpcm8$18e$1_at_nslave1.tin.it>,
"Riccardo Ferrari" <riccardo.ferrari_at_informatica2.it> wrote:
> > If I put this in my INIT<sid>.ORA file:
> >
> > nls_date_format = 'MM-DD-YYYY HH24:MI:SS'
> >
> > I see no difference in my SELECT statement.
>
> I find this very strange ... I know (and I've also just tried) that
it must
> really change the date format.
> Just a silly question: you know you have to shutdown and restart the
> instance after changing the parameter file, do you?
> I really don't find any other sensible explanation.
>
> Bye
> Riccardo
>
> Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com> wrote in message
> 7vmvqj$1qq$1_at_nnrp1.deja.com...
> > I have a question about the use of the NLS_DATE_FORMAT parm. If I
> > don't have it set anywhere, then I see this:
> >
> > SQL> select sysdate from dual;
> >
> > SYSDATE
> > ---------
> > 02/NOV/99
> >
> Do I misunderstand, or am I
> > missing something that is supposed to be obvious?
> >
> > - Ed Stevens
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Nov 03 1999 - 09:30:38 CST