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

Reply via email to