FIXED_DATE

Property	Description
Parameter type	String
Syntax	FIXED_DATE = [YYYY-MM-DD-HH24:MI:SS (or the default Oracle date format) | NONE]
Default value	There is no default value.
Modifiable	ALTER SYSTEM
Basic	No

FIXED_DATE enables you to set a constant date that SYSDATE will always return instead of the current date. To undo a fixed date setting, specify FIXED_DATE=NONE. This parameter is useful primarily for testing. The value can be in the format shown above or in the default Oracle date format, without a time.

Note:

1. The FIXED_DATE parameter can be set in INIT.ORA or can be set dynamically using the command: ALTER SYSTEM SET FIXED_DATE = 'DD-MON-YY';

Unset FIXED_DATE by using the command: ALTER SYSTEM SET FIXED_DATE=NONE;

Once this command has been issued, SYSDATE will return to normal functionality.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘FIXED_DATE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
fixed_date		TRUE	FALSE	IMMEDIATE	TRUE	FALSE	fixed SYSDATE value

Oracle initializatoin parameters