Oracle Tutorial

  • Home
  • Start Here
  • Basics
  • Advanced
    • Oracle View
    • Oracle Index
    • Oracle Synonym
    • Oracle Sequence
    • Oracle Administration
  • PL/SQL
  • Functions
    • Aggregate Functions
    • Analytic Functions
    • Comparison Functions
    • Date Functions
    • String Functions
  • API
    • Python Oracle
Home / Oracle Date Functions / Oracle SESSIONTIMEZONE

Oracle SESSIONTIMEZONE

The Oracle SESSIONTIMEZONE function returns the time zone of the current session.

Syntax

The SESSIONTIMEZONE does not require any argument therefore its syntax is straightforward:

SESSIONTIMEZONE

Return value

The Oracle SESSIONTIMEZONE function returns either a time zone offset, which is a character type in the format [+|-]TZH:TZM e.g., -07:00 or a time zone region name e.g., America/Denver

Examples

The following example returns the session time zone:

SELECT SESSIONTIMEZONE FROM dual;

Remarks

The session time zone value can be set using the ALTER SESSION statement as follows:

ALTER SESSION SET TIME_ZONE = '-07:00';

In this tutorial, you have learned how to use the Oracle SESSIONTIMEZONE function to get the current session time zone.

  • Was this tutorial helpful?
  • YesNo
Previous Oracle ROUND
Next Oracle SYSDATE

Oracle Functions

  • Aggregate Functions
  • Analytic Functions
  • Comparison Functions
  • Date Functions
  • String Functions

Oracle Date Functions

  • ADD_MONTHS
  • CURRENT_DATE
  • CURRENT_TIMESTAMP
  • DBTIMEZONE
  • EXTRACT
  • FROM_TZ
  • LAST_DAY
  • LOCALTIMESTAMP
  • MONTHS_BETWEEN
  • NEXT_DAY
  • NEW_TIME
  • ROUND
  • SESSIONTIMEZONE
  • SYSDATE
  • SYSTIMESTAMP
  • TO_CHAR
  • TO_DATE
  • TRUNC
  • TZ_OFFSET

About Oracle Tutorial

OracleTututorial.com website provides Developers and Database Administrators with the updated Oracle tutorials, scripts, and tips.

Search

Recent Tutorials

  • Oracle Implicit Statement Results
  • Calling PL/SQL Stored Functions in Python
  • Calling PL/SQL Procedures in Python
  • Managing Transaction in Python
  • Deleting Data From Oracle Database in Python

Site Links

  • Oracle Books
  • About
  • Contact
  • Privacy Policy
  • Terms of Use

Copyright © 2021 Oracle Tutorial. All Rights Reserved.