Trouble working with different timezones
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 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?