Quite a complex scenario we are trying to solve but should be able to understand.
We're developing a task executer that runs on a server with a certain timezone.
The tasks run every day at a defined time, but in different timezones.
We're saving in database at what time we want to execute the task, and in what timezone (don't go to the save in UTC pitfall, as with DST it will be at different actual times)
What I want to do if when opening a task from the database, convert 02:00 Europe/Madrid, either to UTC or to local (server) time.
I've found the class HS.Timezone.Server.Service but doesn't solve quite the problem.
Is there any method in intersystems to convert a timestamp from a timezone, to UTC or local?
Apparently Intersystems products don't include the tz database, so it's not possible to do it straightforward. The solution is to call java or python via their embedded mechanisms from intersystems IRIS/Cache.