View database timezone name

[kishore.giri]

How to view the database timezone name?

I want to see my current timezone for my database i.e not in the format 'TZh:TZm' intead I want in the format e.g. 'Asia/Calcutta'?

Plz give me the data dictionary query or any other commands help.

Regards
Kishore

[debasisdas]

What is the database that you are using and which version ?

[susarlasireesha]

how to view the database timezone name? i want to see my current timezone for my database i.e not in the format 'tzh:tzm' intead i want in the format e.g. 'asia/calcutta'? plz give me the data dictionary query or any other commands help. Regards kishore

u can find out the database time zone by usinng
select dbtimezone from dual
u can also alter the database time zone by
alter database set time_zone='asia/calcutta';

the alter database set time_zone statement returns an error if the database contains a table with a timestamp with local time zone column and the column contains data.the change does not take effect until the database has been shut down and restarted.

u can change session time zone by following comman alter session set time_zone='asia/hong_kong';