Oracle Date/Time Function - Oracle/PLSQL SESSIONTIMEZONE Function






This Oracle tutorial explains how to use the Oracle/PLSQL SESSIONTIMEZONE function.

The Oracle/PLSQL 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.

SESSIONTIMEZONE returns the database session time zone.

Syntax

The syntax for the Oracle/PLSQL SESSIONTIMEZONE function is:

SESSIONTIMEZONE

There are no parameters or arguments for the SESSIONTIMEZONE function.

Example


SQL> select SESSIONTIMEZONE from dual;

SESSIONTIMEZONE
-----------------------------------------
-07:00

SQL>