FIXED_DATE Init.ora parameter

Setting this parameter to a specified timestamp will make the time constant for the database engine (the clock will not tick) FIXED_DATE is a dynamic parameter and can be changed using the ALTER SYSTEM command.

SQL> ALTER SYSTEM SET FIXED_DATE=’2009-09-22-13:00:00′;

Once you set parameter, the value will be returned when ‘sysdate()’ is used in the [...]

Share