Post reply

Regional settings on instance SQl Server 2008 R2

  • August 2, 2013 at 4:58 am

    #395239

    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

  • August 6, 2013 at 8:57 am

    #1638975

    Take a look here:

    http://support.microsoft.com/kb/173907

  • August 7, 2013 at 11:58 pm

    #1639620

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply