Re: Time zone for a Date and Time

Have you tried the Convert Date and Time Format (QWCCVTDT) API? That works nicely for this sort of thing.

You're right, there's one hour each year where the time is repeated, and it can't know.  The notes at the bottom of the API page explain how this is handled, and how you can control it if you wish.

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/apis/qwccvtdt.htm


On 5/3/2019 12:49 PM, Slanina, John via RPG400-L wrote:

After thing about it more, it is impossible to do. Nov 2 2019 1am happens two times... so it would be impossible to know it that as EST or EDT time.

I was told the PHP had a library that could do it. But I cannot see how it could work.


I understand that if the system time was that I can look at the system value and get the offset.


Thanks
John Slanina





On 5/3/19, 1:37 PM, "RPG400-L on behalf of John Yeung" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx on behalf of gallium.arsenide@xxxxxxxxx> wrote:

On Fri, May 3, 2019 at 12:49 PM Steve M via RPG400-L
<rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:
> This table has every "spring forward/fall back" from when it first began and going forward for longer than any of us will be around, for every time zone in the world.
Hmm... the ones in the future can change (due to new laws or new
political boundaries)....
> It does not handle those places that do not change, like AZ and such, but for my purposes it was close enough.
That's quite interesting. If it has every time zone in the world, it
*should* have AZ as a separate entry from the rest of U.S. Mountain
Time. The "tz database" is pretty much standard for this kind of
thing:
https://en.wikipedia.org/wiki/Tz_database
Actually, AZ has two entries in that database, because part of the
state does observe Daylight Time.
But that database is relatively complicated, and most interfaces to it
have dedicated maintainers who publish regular updates. You wouldn't
roll your own; you'd periodically grab the update. So it sounds like
you're not using that database.
John Y.
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com