BTW, I forgot that there are some plsql procs, which allow conversion to utc and get offset.
If she chooses EST5EDT or US/Eastern then all the calculations can be made.
It is linked by tz_id of 509 into timezone_rules.
Daylight time goes from April 7 at 7AM (GMT) until Oct 27 5:59:59 GMT.
Therefore you can calculate from there. Note that local times are in the table also.
Timezones are not an easy issue. I am on my way to a picnic so I can't write much more but if you still have a problem I can write up a little doc tomorrow.
