Hi everybody,

I need a clarification regarding the NLS_DATE parameter.

I have set my NLS_DATE as 'MM/DD/YYYY'. After starting the instance and i verified the values of the parameters through V$parameter as well as
svrmgrl > show parameters nls_date

it display as the above said format.

But at SQL> select sysdate from dual;
displays 02-Apr-01 why?