Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | String |
Syntax | FIXED_DATE = YYYY-MM-DD-HH24:MI:SS (or the default Oracle date format) |
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. 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.