如何获取SQLServer时区名称 [英] How to get SQLServer Time Zone Name

问题描述

我正在寻找一个查询以获取要在用户界面中放置的SQLServer的时区

目前，我使用了

在SQL

Hi,

I am looking for a query to get timezone of SQLServer to dislay in user interface

Presently I used

At SQL

select DATEDIFF(n,GETDATE(),GETUTCDATE())

哪个返回offset

Which returns offset

string s = "";
string datestring = "";
int i = Convert.ToInt16(-OffSet from SQL-)
int j = -i / 60;
int k = -i % 60;
s = i < 0 ? "+" : "-";
if (j < 9)
    datestring = s + "0" + j.ToString() + ":" + k.ToString();
else
    datestring = s + j.ToString() + ":" + k.ToString();
foreach (var timeZoneInfo in TimeZoneInfo.GetSystemTimeZones())
{
    if(timeZoneInfo.DisplayName.ToString().Contains(datestring))
    Response.Write(timeZoneInfo.DisplayName.ToString()+ "<br/>");
}

在此先感谢:confused:

Thanks in advance:confused:

推荐答案

浏览 SQL 2005时区转换功能 [ ^ ]，里面可能有什么可以帮助您的.

Have a look through SQL 2005 Time Zone Conversion Functions[^], there may be something in there to help you.

这篇关于如何获取SQLServer时区名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！