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
select sessiontimezone from dual; -- -- SESSIONTIMEZONE -- ----------------------- -- +01:00 alter session set time_zone = '-3:00'; select sessiontimezone from dual; -- -- SESSIONTIMEZONE -- --------------------- -- -03:00