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 queries/application.
To see the server time, you can use systimestamp.


SQL> set lines 100
SQL> select sysdate, systimestamp from dual;

-------					-------------------------
2009 09 22 13:00:00 	10-DEC-09 AM -06:00

This is usually used for testing/development purposes, when the application logic depends on a specific date/time combination.

To set the date back to the ‘system’ clock, set the parameter to ‘none’

SQL> alter system set fixed_date='none';

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>