Click here to Skip to main content
13,003,930 members (123,564 online)
Rate this:
Please Sign up or sign in to vote.
See more: , +
I am using C# 2.0 to create a windows form application. I have different exchanges of different countries which are in different time zones.

To know their exact time running , I have a timezone field in my database which saves display name of the timezone.

Eg, I have an exchange NASDAQ which is located in New York and hence its timezone i have saved in my db is UTC-05:00 Eastern time(US and Canada).

The problem is that i am picking their time from windows registry at the time when server starts. Some of the machines contains timezone in GMT too. So comparing them with my database is difficult.

Hence i found an alternative that I should just match their offsets rather than matching whole display name. But the new problem arises that how to auto update DayLightSavings time.

Eg, UTC-06:00 Central America does not have any daylight saving time but
UTC-06:00 Mexico City includes 1 hour as daylight saving time.

So If I have an exchange in Central America timezone, its time would be 1 hour before the exchange in Mexico.

Please kindly suggest me how to deal with such issue.
Posted 8-Aug-12 21:16pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170627.1 | Last Updated 9 Aug 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100