Search notes:

Oracle: DBTIMEZONE / SESSIONTIMEZONE

dbtimezone and sessiontimezone return the value of the database's or session timezone either in +hh:mm format or as name of a time zone, depending on the most recent modification of the time zone using create database or alter database or alter session set time_zone.

select
  dbtimezone
from
  dual;
--
-- DBTIME
-- ------
-- +02:00

Github repository Oracle-Patterns, path: /SQL/functions/date_related/dbtimezone.sql

select
  sessiontimezone
from
  dual;
--
-- SESSIONTIMEZONE
-- -----------------------
-- +01:00


alter session set time_zone = '-3:00';

select
  sessiontimezone
from
  dual;
--
-- SESSIONTIMEZONE
-- ---------------------
-- -03:00

Github repository Oracle-Patterns, path: /SQL/functions/date_related/sessiontimezone.sql

Oracle: DBTIMEZONE / SESSIONTIMEZONE

See also