Mathew Lambert · Dec 14, 2020 go to post

System configuration. There are so much settings all over the application that it would be great to have a configuratino wizard divided into categories.

Mathew Lambert · Jan 14, 2021 go to post

The issue with this option is that on a productive environment, inmediately after purguing the queries, I've got new queries.

Mathew Lambert · Jan 14, 2021 go to post

Until now in caché we where checking $ZERROR, but as InterSystems is descouraging the use of that variable, I don't know how to surely test this command.

Mathew Lambert · Oct 22, 2021 go to post

Using any of both method I've got the same problem, how do I know what is the offset for "Europe/Madrid" today, tomorrow, or any given day?

Mathew Lambert · Oct 22, 2021 go to post

It shows the server offset to UTC.

My tasks look like this:

Take out trash 08:00 Europe/Madrid
Take out trash 08:00 Asia/Tokyo
Take out trash 08:00 America/New York

These tasks are executed every day, and need to be executed on my server that is in Africa/Cairo timezone, but need to be executed at the correct UTC time.

Today (22 October 2021) the UTC conversions for 08:00 of the indicated timezones are as following

06:00 22.Oct

23:00 21.Oct

12:00 22.Oct

But on november the 10th it will be

07.00 10.Nov

23:00 9.Nov

13:00 10.Nov

That times are the UTC times when I need to execute my task.

How can I convert 22 October 2021 08:00 Asia/Tokyo to 21 October 2021 23:00 UTC

Mathew Lambert · Oct 23, 2021 go to post

Of course future can't be predicted but each release can have the up to date DB.

Will do it via Java or Py with a connector

Mathew Lambert · Oct 25, 2021 go to post

That's for sure, changing the $Timezone is the last approach.

However I've been testing with HS.Timezone.Server.Service and I think that I'm getting something useful, and seeing the docs I'm seeing that it has the TZ database embedded