>Thanks Hilmar
>since am dealing with only 8 states probably i should hard code these GMS times.
>am using table from following link
>
http://wwp.greenwichmeantime.com/time-zone/australia/To make the "hard-coding" more flexible, you could have a table with the state code, and the equivalent GMT / UTC time.
Also, if you work with different time zones, I would recommend using GMT / UTC as the standard time, since that is used world-wide as such.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)