2.407 SYSDATE_AT_DBTIMEZONE

SYSDATE_AT_DBTIMEZONE enables special handling for the date and time value returned in calls to SYSDATE and SYSTIMESTAMP.

Depending on the value of SYSDATE_AT_DBTIMEZONE, you see either the date and time based on the default Autonomous AI Database time zone, Coordinated Universal Time ‎(UTC)‎, or based on the time zone that you set in your database.

Note:

This parameter is valid only for Oracle Autonomous AI Database Serverless. On other types of Oracle databases, the value of this parameter is ignored.

See Also:

Using Oracle Autonomous AI Database Serverless for more information about this parameter