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'
Posted by Sandesh Segu
Labels: ,

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

April 24, 2014 at 10:16 PM

Post a Comment

Subscribe to: Post Comments (Atom)

Ads