UK Datacentre: SQL Server 2008 Time Zone

Discussion in 'Databases' started by Kazooie, Aug 11, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Kazooie

    Kazooie

    Hi, When I query the timezone offset to UTC on the SQL Server machine like this:
    DATEDIFF(HOUR,GETDATE(),GETUTCDATE())

    it returns '-1'

    How is this possible. The SQL Server is located in the UK data center. Is there a way to change the time zone to UTC?

    Thanks for your help.
     
    Kazooie, Aug 11, 2009
    #1
  2. raymondp

    raymondp

    I'm afraid this is a server wide setting and cannot be updated without the possibility of adversely affecting other accounts.
     
    raymondp, Aug 11, 2009
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page