Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 50 of 188


FIXED_DATE

Parameter type: 

String 

Syntax: 

YYYY-MM-DD-HH24:MI:SS (or the default Oracle date format) 

Parameter class: 

Dynamic. Scope = ALTER SYSTEM. 

Default value:  

None 

FIXED_DATE lets you 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.

Specify the value without quotation marks or with double quotation marks. Do not use single quotation marks. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index