DBTIMEZONE

Purpose

This function returns the time zone of the current database instance. The time zone of OceanBase Database is always +00:00 and cannot be modified.

Syntax

DBTIMEZONE

Return type

VARCHAR2.

Examples

Return the time zone of the current database instance.

obclient> SELECT DBTIMEZONE FROM DUAL;
+------------+
| DBTIMEZONE |
+------------+
| +00:00     |
+------------+
1 row in set