Home » RDBMS Server » Server Administration » Australia Time Zone settings
Australia Time Zone settings [message #251046] Thu, 12 July 2007 05:05 Go to next message
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.
Re: Australia Time Zone settings [message #251047 is a reply to message #251046] Thu, 12 July 2007 05:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which OS?

Regards
Michel
Re: Australia Time Zone settings [message #251049 is a reply to message #251046] Thu, 12 July 2007 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: Australia Time Zone settings [message #251050 is a reply to message #251047] Thu, 12 July 2007 05:14 Go to previous messageGo to next message
somavamshi
Messages: 17
Registered: July 2007
Location: bangalore
Junior Member
AIX 5
Re: Australia Time Zone settings [message #251053 is a reply to message #251050] Thu, 12 July 2007 05:24 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ls -l /usr/share/lib/zoneinfo/Australia

Regards
Michel
Previous Topic: SGA_MAX_SIZE auto created -- create database command manully
Next Topic: Environment Variables for Upgrading
Goto Forum:
  


Current Time: Thu Dec 08 02:38:09 CST 2016

Total time taken to generate the page: 0.18831 seconds