Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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)



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