Home » RDBMS Server » Server Administration » Timezone setup
Timezone setup [message #612764] Thu, 24 April 2014 12:02 Go to next message
krish96
Messages: 74
Registered: October 2012
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: 26766
Registered: January 2009
Location: SoCal
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: 74
Registered: October 2012
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: 68625
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: Thu Mar 28 11:32:43 CDT 2024