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:

  1. AnonymousApril 24, 2014 at 10:16 PM

    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

    ReplyDelete