I have a zipcode table with fields for UTC and DST. UTC is stored as -8 etc and DST is stored as Y or N.
The users of the application place a lot of phone calls across the country and need to know what time it is in the various zips. I need some code I can put in T-SQL/Stored Procedure that will tell me what time it is in the various zipcodes. I will then incorporate that into my procedure.
Currently I have been doing a basic math from our timezone PST to the zipcodes time zone using the UTC field without thinking about DST. Now that needs to change