On Tue, 2 Feb 2016 08:46:16 -0700, Sri h Kolusu wrote:
>Ravi,
>
>Conversion of GMT time to EST is quite simple. You just need to subtract 5
>hours (18,000 seconds) from the time field. But remember when you subtract
>you need to subtract 1 ...
>
And Ravi has clarified that he wants the technique to be aware of Daylight
Saving Time. And I recall the rules in the U.S. changed in 2006. And more
recently in the Nation of Samoa.
Sigh. DFSORT (and DB2) ought to be savvy to:
https://www.iana.org/time-zones
(Java knows this. Linux knows this. ... )
-- gil
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN