• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / Oracle SESSIONTIMEZONE Function

Oracle SESSIONTIMEZONE Function

November 5, 2012 by techhoneyadmin

Oracle SESSIONTIMEZONE FunctionOracle SESSIONTIMEZONE Function is used to get current session’s time zone as a time zone offset or even as a time zone region name.


Oracle SESSIONTIMEZONE Function Syntax

 SELECT SESSIONTIMEZONE
FROM table_name;

Oracle SESSIONTIMEZONE – Using SQL SELECT Statement Example

Oracle SESSIONTIMEZONE Function is used with the SQL SELECT Statement.

For example, the Oracle SESSIONTIMEZONE query below returns the current session’s time zone.

SELECT SESSIONTIMEZONE
FROM DUAL;

May return “-07:00”
Or it may return “:+5:30”
Depending upon the latest session time zone value as set by the ALTER SESSION command.


Filed Under: function Tagged With: how to use sessiontimezone function in oracle database query, how to use sessiontimezone function in oracle plsql, how to use sessiontimezone function in oracle sql, sessiontimezone function in oracle plsql, sessiontimezone function in oracle sql, SESSIONTIMEZONEPLSQL, syntax and example of sessiontimezone function in oracle database query, syntax and example of sessiontimezone function in oracle plsql, syntax and example of sessiontimezone function in oracle sql, using sessiontimezone function in oracle database query, using sessiontimezone function in oracle plsql, using sessiontimezone function in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in