To find out the database time zone use the following query:
SELECT DBTIMEZONE FROM DUAL;
To find out the current session time zone use the following query:
SELECT SESSIONTIMEZONE FROM DUAL;