[Oracle11g]Check DB Timezone and Session Timezone

Use the following SQL Queries to check the Database Timezone and Session Timezone values.

Database Timezone

The database timezone function returns the timezone specified when Database was installed or the CREATE DATABASE script was executed .Output would be a value like -08:00  or +5:30 etc

SELECT DBTIMEZONE FROM DUAL;

Session Timezone 

Returns the timezone of the current session, Output would be a value like -08:00  or +5:30 etc

SELECT SESSIONTIMEZONE FROM DUAL;