How to set sysdate in Oracle Database

Hi,

Usually SYSDATE depands on OS date but if we need to set or fixed sysdate any other date from current sysdate then we can achieve this task by one parameter at system level.

FIXED_DATE parameter name.

Value = Date / NONE

SQL> select sysdate from dual;
SYSDATE

---------

27-JUL-09

SQL> alter system set fixed_date='25-FEB-09';
System altered.

SQL> select sysdate from dual;
SYSDATE

---------

25-FEB-09

SQL> alter system set fixed_date='none';
System altered.

SQL> select sysdate from dual;
SYSDATE

---------

27-JUL-09
SQL>