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