Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Regional settings on instance SQl Server 2008 R2 Expand / Collapse
Author
Message
Posted Friday, August 2, 2013 4:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 4, 2013 5:36 AM
Points: 70, Visits: 36
Hello:

Is it possible to set regional settings of date and time to an instance of SQL Server 2008 R2?

My need is that in a clustered environment (2 nodes) I would like create SQL server instances with different time zone in order that the use of the getdate() function return the right value depending on the instance in which we are.

Do you know any alternative to this need?

Thanks in advance.

Jesús
Post #1480334
Posted Tuesday, August 6, 2013 8:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:11 PM
Points: 246, Visits: 620
Take a look here:

http://support.microsoft.com/kb/173907
Post #1481384
Posted Wednesday, August 7, 2013 11:58 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 4, 2013 5:36 AM
Points: 70, Visits: 36
Thank you very much for your answer.

My need is not a date formatting issue depending on the language of the instance as the article says.

My need is to manage diferent time zones (GMT +- xxxxxx) in the diferents sql server instances runnin in the same physical server.

For example, the function getdate() executed at the same time in an instance with timezone 'Madrid' and in an instance with timezone 'Chile' I would like it returns '08/08/2013 08:00:00' for the 'Madrid' instance and '08/08/2013 02:00:00' for the 'Chile' instance.

Is it posible by configuration and/or installation settings?

Thanks again in advance.

Jesús
Post #1482145
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse