Skip to content
DBCode

SESSIONTIMEZONE

SESSIONTIMEZONE( )

Section titled “SESSIONTIMEZONE( )”
  • sessiontimezone(): This is a function in Oracle that does not require any parameters. It returns the time zone of the current session. The output format is a string, in ‘+HH

Example

Section titled “Example”
SELECT SESSIONTIMEZONE
FROM DUAL;

Output

Section titled “Output”
+08:00

Explanation

Section titled “Explanation”

SESSIONTIMEZONE is a function in Oracle that returns the timezone offset of the current session from UTC time. In the example given, it has returned ‘+08:00’, which means the current session’s timezone is 8 hours ahead of UTC.