Quick Search:
 
 The Oracle PL/SQL SESSIONTIMEZONE Function      [Return To Index] Jump to:  

Term: SESSIONTIMEZONE

Definition:
In Oracle PL/SQL, SESSIONTIMEZONE is a built in function which returns the time zone value for the current session. Its return type format is [+|-]TZH:TZM or time zone region. It can be modified for a session using ALTER SESSION command.

Example Syntax:

SESSIONTIMEZONE


Example Usage:

SQL> SELECT SESSIONTIMEZONE FROM DUAL;

SESSIONTIMEZONE
-----------------------------------------
+05:30



Related Links:

Related Code Snippets:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org