T-SQL query to find the timezone offset of the SQL server | SansSQL

Wednesday, April 16, 2014

T-SQL query to find the timezone offset of the SQL server

Here is a short T-SQL query to find the timezone offset of the SQL server.

SELECT 'UTC'+RIGHT(SYSDATETIMEOFFSET(),6) AS 'TimeZone Offset'

1 comment:

Anonymous said...

I needed to thank you for this great read!! I definitely loved every bit
of it. I have you book marked to check out new things you post…

Feel free to visit my webpage: how to make money on the side

Post a Comment