NLS_DATE_FORMAT
Oracle 10.2 standard
Hi,
I have to change the default date format.
I have issued
alter system set nls_date_format='YYYY-MM-DD HH24:MI:SS' scope=spfile;
It was successfull, but still sysdate showing only dd-mm-yyyy.
I have checked
select * from nls_instance_parameters;
select * from nls_session_parameters;
showing NLS_DATE_FORMAT to new alter system value, but
select * from nls_database_parameters;
showing old NLS_DATE_FORMAT??
I believe alter system and scope=spfile should reset this value forever and should retain after restart of database.