时区转换 [英] Time Zone Conversion

问题描述

我有一个数据集，用于收集互联网服务提供商的互联网服务停机时间。该提供商位于美国东海岸EST，在英国，印度和香港拥有客户。



我需要创建一些类型的查询，计算字段，过滤器或参数，允许用户在过滤后显示其所在国家/地区的事件，以确定停机事件是在
之前还是在其工作时间之后发生，例如，上午08:00和下午17:00在客户的时区。



感谢您的帮助！

解决方案

之前处理类似情况的方法是存储用户的时区在配置表中。

然后，您可以从服务器的时间计算GMT，然后根据用户的时区进行调整。

我是不确定，但可以通过阅读注册表或使用API​​，根据机器的区域设置确定用户的时区。

希望有帮助...

I have a dataset that collects downtime minutes of internet service by an internet provider. This provider is on the U.S. East coast EST and has customers in England, India and Hong Kong.

I need to create some type of query, calculated field, filter or parameter that allows the user after filtering to show events for their country to determine if the downtime event happened before or after their business hours, for example, 08:00 AM and 17:00 PM in the customer's time zone.

Thank you for your help!

解决方案

Hi,

The way I have handled a similar situation before was to store the user's time zone in a configuration table.

You can then calculate the GMT from the server's time and then adjust it based on the user's time zone.

I am not sure but it may be possible to determine the user's time zone based on the machine's Regional Settings by either reading the Registry or using API.

Hope it helps...

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