2.394 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 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 Database Serverless. On other types of Oracle databases, the value of this parameter is ignored.

See Also:

Using Oracle Autonomous Database Serverless for more information about this parameter