CodesJava

Easy learning with example program codes

SESSIONTIMEZONE function in Oracle

SESSIONTIMEZONE is one of the vital Date/Time functions of Oracle. It is used to get the current session’s time zone. The result generated is either as a time zone offset or a time zone region name. The SESSIONTIMEZONE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.

Syntax:

SESSIONTIMEZONE 

Example:

Select SESSIONTIMEZONE
from dual;

Output:

-02:00

Explanation:
The result depends on the timezone value of the Oracle database.

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status