Oracle DBTIMEZONE Function

Oracle DBTIMEZONE Function is used to get the data-base time zone as a time zone offset or even as a time zone region name.

Oracle DBTIMEZONE Function Syntax

SELECT DBTIMEZONE
FROM table_name;

Oracle DBTIMEZONE – Using SQL SELECT Example

Oracle DBTIMEZONE can be used with the SQL SELECT Statement.

For example, the below query returns the data base time zone or time zone offset.

SELECT DBTIMEZONE
FROM DUAL;

May return “+00:00”
Or it may return “:+5:30”

Depending upon the time zone value set in the Oracle data-base