Oracle DBTIMEZONE function.

Preamble

The Oracle/PLSQL DBTIMEZONE function returns the time zone of the database as an offset of the time zone (in the following format: ‘[+|-]TZH:TZM’) or the time zone name.

Oracle/PLSQL syntax of DBTIMEZONE function

DBTIMEZONE

Parameters and function arguments

• There are no parameters or arguments for the function CURRENT_ TIMESTAMP.

The DBTIMEZONE function returns the time zone offset (in the following format: ‘[+|-]TZH:TZM’) or the time zone name.

DBTIMEZONE function can be used in the following versions of Oracle/PLSQL

Let’s consider an example of the DBTIMEZONE function and learn how to use the DBTIMEZONE function in Oracle.

select DBTIMEZONE from dual;

The DBTIMEZONE function can return a value like this:

+00:00

or a value such as this:

-07:00

The return value depends on the time zone value set on your individual Oracle database.

About Enteros

​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​