Oracle Database Discussions

Hi All

My oracle database version is 10201

SQL> select sysdate from dual;

SYSDATE
---------
16-APR-09

SQL> select to_timestamp(sysdate) from dual;

TO_TIMESTAMP(SYSDATE)
------------------------------------------------
16-APR-09 12.00.00 AM


what nls changes to be done in the instance level to get the o/p as (i.e) as 16-APR-09 12.00.00 AM for both the above SQL statement.

Ihave done alter system set nls_date_format='' scope-spfile but it doesn't work .. :(


I can get the query o/p for both same when i change the NLS parameter in seesion level but i need it for instance level.


Thanks
Hariharan.T