OraFAQ Forum: Server Administration » Australia Time Zone settings

Home » RDBMS Server » Server Administration » Australia Time Zone settings

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Australia Time Zone settings [message #251046]

Thu, 12 July 2007 05:05

somavamshi
Messages: 17
Registered: July 2007
Location: bangalore

Junior Member

Hi ....

We are setting up a system with oracle for Australia for melbourne and sydney.

1) Which timezone I need to setup on OS level Is daylight Savings are used for both Melbourne and Sydney or west and east?
2) Which timezone to setup in database level?

please guide me on this.

Report message to a moderator

Re: Australia Time Zone settings [message #251047 is a reply to message #251046]

Thu, 12 July 2007 05:10

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Which OS?

Regards
Michel

Report message to a moderator

Re: Australia Time Zone settings [message #251049 is a reply to message #251046]

Thu, 12 July 2007 05:12

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SQL> select distinct TZNAME from v$TIMEZONE_NAMES where tzname like 'Australia%' order by 1;
TZNAME
----------------------------------------------------------------
Australia/ACT
Australia/Adelaide
Australia/Brisbane
Australia/Broken_Hill
Australia/Canberra
Australia/Darwin
Australia/Hobart
Australia/LHI
Australia/Lindeman
Australia/Lord_Howe
Australia/Melbourne
Australia/NSW
Australia/North
Australia/Perth
Australia/Queensland
Australia/South
Australia/Sydney
Australia/Tasmania
Australia/Victoria
Australia/West
Australia/Yancowinna

Regards
Michel

Report message to a moderator