在SQL Server中确定远程夏令时 [英] Determining remote daylight saving in sql server

问题描述

我想确定夏令时是否处于活动状态，但是否位于服务器所在的区域之外。

I want to determine the if daylight saving time is active or not, but in a region different to where my server is located.

我的问题是我想检查伦敦的夏令时，我的服务器在加拿大；是否可以找到其他时区的夏令时？

My problem is I want to check the daylight saving of London and my server is in Canada; is it possible to find the daylight saving of a different time zone?

推荐答案

您需要部署DST表并查找您想要的区域的夏令时时间。 DST由各种组织发布，并定期刷新。您需要了解的是，DST不能通过算法确定，只能根据各个地区的各个立法机构的设置进行查询，并且经常更改。例如，这是当前的2013 DST表。保持应用程序的DST查询表为最新状态对于您的应用程序来说是一项定期任务。

You need to deploy a table of DST and look up the DST time for the region you want. DST are published by various organizations and refreshed periodically. What you need to understand is that DST cannot be determined by an algorithm, it can only be looked up as is set by various legislative bodies for various regions, and changes frequently. For example here is the current 2013 DST table. Maintaining your application's DST look-up table current would be a periodic task for your application.

这篇关于在SQL Server中确定远程夏令时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！