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 22:16pm

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

  Print Answers RSS
0 DamithSL 245
1 Sergey Alexandrovich Kryukov 207
2 OriginalGriff 175
3 Peter Leow 160
4 Afzaal Ahmad Zeeshan 85
0 OriginalGriff 7,380
1 DamithSL 5,359
2 Sergey Alexandrovich Kryukov 4,944
3 Maciej Los 4,906
4 Kornfeld Eliyahu Peter 4,514


Advertise | Privacy | Mobile
Web03 | 2.8.141223.1 | Last Updated 9 Aug 2012
Copyright © CodeProject, 1999-2014
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