SESSIONTIMEZONE

SESSIONTIMEZONE is a built-in SQL function. It returns the time zone offset of the current session, in the format of '+HH:MM' or '-HH:MM'. The session's time zone offset is initially determined at login based on the environment of the client or the database server. The value can be modified by the user during the session.

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

SELECT SESSIONTIMEZONE
FROM DUAL;

Output

+08:00

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.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.