All Products
Search
Document Center

DBTIMEZONE

Last Updated: Jun 18, 2021

The DBTIMEZONE function returns the time zone of the current database instance. In ApsaraDB for OceanBase, the time zone is always +00:00 and cannot be changed.

Syntax

DBTIMEZONE

Parameters

None

Return type

VARCHAR2 data type

Examples

Execute the following statement:

SELECT DBTIMEZONE FROM DUAL;

The following query result is returned:

+------------+
| DBTIMEZONE |
+------------+
| +00:00     |
+------------+