We want to start collecting timezones for each of our addresses in the database. What is the best practice to store the timezones? How would you go about acquiring timezones for the existing address records?
I'm using Microsoft SQL server, .net mvc, C#. Any suggestions would be greatly appreciated.