Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

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. 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index