Determining the time zone with a user defined function [email protected] (Simon Hutchinson)

​In a previous post I wrote about calculating the time in different places in my IBM i partition. I mentioned at the end of that post that I had created a User Defined Function, UDF, to perform that calculation for me. This post is to show you how I did that. As I described in the previous post I can calculate the UTC by using the CURRENT_TIMEZONE special register: UTC time = CURRENT_TIMESTAMP – CURRENT_TIMEZONE It is not possible to know what other time zone’s difference is from UTC without using a table to contain the following information: Read more » Read More 

Verified by MonsterInsights