Printable View
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
What is the database that you are using and which version ?
[quote=kishore.giri;23188]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[/quote]
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';
<br>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.
<br>u can change session time zone by following comman alter session set time_zone='asia/hong_kong';