Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > fixed_date

fixed_date

Oracle 11.1.0:

Parameter Name:fixed_date
Description:fixed SYSDATE value
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:fixed_date
Description:fixed SYSDATE value
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:fixed_date
Description:fixed SYSDATE value
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:fixed_date
Description:fixed SYSDATE value
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

Parameter Name:fixed_date
Description:fixed SYSDATE value
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.0.6:

Parameter Name:fixed_date
Description:fixed SYSDATE value
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 7.3.4:

Parameter Name:fixed_date
Description:fixed SYSDATE value
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Related Error Messages:

ORA-00065: initialization of FIXED_DATE failed
    Cause: The FIXED_DATE string was not in date format yyyy-mm-dd:hh24:mi:ss.

    Action: Make sure the initialization parameter is in the correct date format.

This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ fixed_date ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US