Oracle/PLSQL: SessionTimeZone Function
In Oracle/PLSQL, the sessiontimezone function returns the current session's time zone as a time zone offset (in the following format: '[+|-]TZH:TZM') or a time zone region name.
The syntax for the sessiontimezone function is:
sessiontimezone
Applies To:
- Oracle 9i, Oracle 10g, Oracle 11g
For Example:
select sessiontimezone
from dual;
The sessiontimezone function might return a value like this:
+00:00
or a value such as this:
-07:00
The value returned depends on how the user specified the session time zone value in the most recent ALTER SESSION statement. An example of an ALTER SESSION command is:
ALTER SESSION SET TIME_ZONE = '-7:0';