TimeZone based on statecode

[gayatri]

Hi All..

I Have a requierment such that I need to find out the timezones of US based on statecode. for ex-.I have some task i need to find out the response time of that task from the task started time till the task completed.Is there any way to find this? though I am tracking the starttime and completed date in table but it is not based on the statecode..plz let me know at the earliest if anyone can find a solution .

Thanks in advance

[Plater]

Timezones are not really done by state (especially when you mix daylight savings in). I believe they are done by COUNTY in each state.

You could get really close however by making a little lookup table.
50 entries, two columns. One column for statecode and one column for the offset from GMT?