PDA

View Full Version : UK Datacentre: SQL Server 2008 Time Zone


Kazooie
08-11-2009, 06:46 AM
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.

raymondp
08-11-2009, 09:42 AM
I'm afraid this is a server wide setting and cannot be updated without the possibility of adversely affecting other accounts.