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 AI Database 26ai.

• 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 AI Database 26ai.

See Also:

• Oracle AI Database SQL Language Reference for information about the SYSDATE function

• Oracle AI Database SQL Language Reference for information about the SYSTIMESTAMP function