Re: Time Zone Computation

On Fri, 2018-12-28 at 14:22 -0600, txpenguin1@xxxxxxxxxxx wrote:

All,



Seem to have hit a wall that I hope others have scaled before me and may be
able to help me over.



I have an event that has occurred in a specific city within the US. I know
the date and time of the event. The SOAP service I am working with uses the
"XMLGregorianCalendar Class" for its interface. The format is
"2018-12-28T13:15:05-05:00" where it is CCYY-MM-DD with a 'T' to separate
the date and time, followed by HH:MM:SS followed by a hyphen and then the
HH:MM off-set to GMT. If the off-set was static that would be great, but as
we all know thanks to Daylight Savings Time and Standard Daylight Time the
off-set changes twice each year. However, let us not forget the cities
and/or states where no change is made (like parts of Arizona).



So, my dilemma is this - based upon a specific date and time, in a specific
city/state, how can I compute the number of hours difference to GMT for that
moment?

I don't currently have access to a box, so this is from memory and a
quick google...

The IBM QWCCVTDT API (1) used in conjunction with the *TIMZON objects
(2) in the optional parameter group 1 might give you what you need to
convert to the standard UTC (0) format.

(1)
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_71/apis/qwccvtdt.htm
(2) I think these are the *TIMZON objects the api is referencing...
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzati/rzatitimezone.htm

I'll take anything that I can do within the System i (BTW, we are on O/S 7.2
in case of any release-specific solutions), or an off-platform SOAP/REST
service I can call, only if it is free. You know how those multi-billion
dollar corporations are on letting loose with a nickel for a paid service.



Merry Christmas (belated), Happy New Year (in advance), and Happy Holidays
(in general) to all, and as always, thanks in advance for any assistance.



Steve Meisinger