R: Specifying NLS_DATE_FORMAT

> 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.
Received on Wed Nov 03 1999 - 07:17:25 CST