SESSIONTIMEZONE

Syntax

SESSIONTIMEZONE()
RETURNS text;

Overview

The sessiontimezone function returns the timezone of the current session as a text value.

Internally, it calls the show_timezone() function to view the time zone of the current session and then converts it to text, and returns it.

Example

select oracle.sessiontimezone();

 sessiontimezone 
-----------------
 Asia/Seoul
(1 row)