Oracle/PLSQL: DbTimeZone Function
In Oracle/PLSQL, the dbtimezone function returns the database time zone as a time zone offset (in the following format: '[+|-]TZH:TZM') or a time zone region name.
The syntax for the dbtimezone function is:
dbtimezone
Applies To:
- Oracle 9i, Oracle 10g, Oracle 11g
For Example:
select dbtimezone
from dual;
The dbtimezone function might return a value like this:
+00:00
or a value such as this:
-07:00
The value returned depends on the time zone value set in your individual Oracle database.