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?