Is there a web service of some sort (or any other way) to pull a current time zone settings for a (US) city. For the parts of the country that don't follow the Daylight Saving Time and basically jump timezones when everyone else is switching summer/winter time… I don't fancy creating own database of the places that don't follow DST. Is there a way to pull this data on demand?
I need this for the database server (not for client workstations) – there entities stored in the database that have City, State as properties. I need know current timezone for these entities at any moment of time.