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