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.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® Database Reference 11g Release 2 (11.2)

New and changed documents:

HTML

PDF