Home » RDBMS Server » Server Administration » Timezone setup
Timezone setup [message #612764] Thu, 24 April 2014 12:02 Go to next message
krish96
Messages: 26
Registered: October 2012
Junior Member
Hello Guru's..!!

I have a question about the time zones

Can we change or setup the timezone on oracle database 11gr2, is there a timezone feature to set apart from the OS timezone. Please advice ..

Thank you..
Re: Timezone setup [message #612768 is a reply to message #612764] Thu, 24 April 2014 12:08 Go to previous messageGo to next message
BlackSwan
Messages: 22484
Registered: January 2009
Senior Member
Oracle obtains time & timezone details only from the OS
Re: Timezone setup [message #612770 is a reply to message #612768] Thu, 24 April 2014 12:16 Go to previous messageGo to next message
krish96
Messages: 26
Registered: October 2012
Junior Member
Thanks for the prompt response
Re: Timezone setup [message #612775 is a reply to message #612770] Thu, 24 April 2014 12:54 Go to previous message
Michel Cadot
Messages: 58499
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can use ALTER DATABASE to change the database timezone.

Previous Topic: Centralizing two instances
Next Topic: Control files in ASM.
Goto Forum:
  


Current Time: Wed Jul 23 09:36:03 CDT 2014

Total time taken to generate the page: 0.26146 seconds