How to Override SYSDATE function in Oracle9i

[tamilselvan]

SQL> show parameter fixed_date

NAME                   TYPE        VALUE
--------------- ----------- ------------------------------
fixed_date             string      NONE
SQL> alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS' ;

Session altered.

SQL> select sysdate from dual;

SYSDATE
--------------------
16-AUG-2006 12:23:52

SQL> alter system set fixed_date = '12-DEC-2007 00:00:00' ;

System altered.

SQL> select sysdate from dual ;

SYSDATE
--------------------
12-DEC-2007 00:00:00

SQL> alter system set fixed_date = none ;

System altered.

SQL> show parameter fixed_date

NAME                       TYPE        VALUE
-------------------- ----------- ------------------------------
fixed_date                  string      NONE
SQL>


SQL> alter session set fixed_date = '12-DEC-2007 00:00:00' ;
alter session set fixed_date = '12-DEC-2007 00:00:00'
                  *
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option

I did not change init.ora file, but changed the parameter temporarily.

Hope this helps .......

Tamil