1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. TIME_AT_DBTIMEZONE

2.401 TIME_AT_DBTIMEZONE

TIME_AT_DBTIMEZONE specifies whether time-dependent database operations use the time zone of the database host system or the time zone of the PDB.

Some examples of time-dependent database operations are running the SQL functions SYSDATE and SYSTIMESTAMP, querying table columns of type DATE or TIMESTAMP, using Oracle Job scheduler, performing materialized view refresh, and using Oracle Flashback Technology.

Property Description

Parameter type

String

Syntax

TIME_AT_DBTIMEZONE = { OFF | USER_SQL | DATABASE }

Default value

OFF

Modifiable

No

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

Multiple instances must use the same value.

Values:

  • OFF - For all time-dependent operations, the database uses the time zone of the database host system that was in effect when the database was started. This is the behavior in releases prior to Oracle Database 23ai.

  • USER_SQL - The SQL functions SYSDATE and SYSTIMESTAMP return the date and time based on the DBTIMEZONE setting for the PDB. For all other time-dependent operations, the database uses the time zone of the database host system that was in effect when the database was started.

  • DATABASE - For all time-dependent operations, the database uses the time zone specified by the DBTIMEZONE setting for the PDB.

Note:

This parameter is available starting with Oracle Database 23ai.

See Also: