OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Timezone setup

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

Timezone setup [message #612764]

Thu, 24 April 2014 12:02

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..

Report message to a moderator

Re: Timezone setup [message #612768 is a reply to message #612764]

Thu, 24 April 2014 12:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Oracle obtains time & timezone details only from the OS

Report message to a moderator

Re: Timezone setup [message #612770 is a reply to message #612768]

Thu, 24 April 2014 12:16

krish96
Messages: 74
Registered: October 2012

Member

Thanks for the prompt response

Report message to a moderator

Re: Timezone setup [message #612775 is a reply to message #612770]

Thu, 24 April 2014 12:54

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can use ALTER DATABASE to change the database timezone.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 05:39:04 CST 2024