SQL Server UTC Local Time

Question

is there a function in SQL Server that returns the difference between UTC time and local server time?

Answer 1

If you are using SQL 2008, then using datetimeoffset and related functions is much better. But, assuming you are talking about the current offset, you can do something like:

DATEDIFF(minute, GETUTCDATE(), GETDATE())