What I suppose is u can use one more table where u can store the time diff betwn GMT and the state time for each state and check for the time by adding or subtracting the time diff as applicable.
Regards
Sudeep
Regards,
Sudeep Kukreti
________________________________________________________________
HELP is an act, do it, let it go.
LOVE is a gift, take it, let it grow.
PATIENCE is a sign we should wear, let it show