Good day Donna,
at zOS we have the CURRENT TIME ZONE, for example I am 1 hour ahead from UTC, so, if I ask for the CURRENT TIME ZONE, it returns 010000, being the first to digit the difference in hours: (CURRENT TIME ZONE - IBM Documentation)
select current time zone from sysibm.sysdummy1;
---------+---------+---------+---------+--------
10000,
If I want to know the current time in UTC, I would query this:
select current timestamp - current time zone from sysibm.sysdummy1;
---------+---------+---------+---------+---------+---------+--------
2023-03-13-07.34.23.186439
So with this CURRENT TIME ZONE you can convert it to the "-04:00" of your Example.
Hope that helps!
------------------------------
Soledad Martinez
------------------------------
Original Message:
Sent: Fri March 10, 2023 11:44 AM
From: Donna Stinson
Subject: Timestamp with time zone
Good afternoon -
I need to convert a date; 2005-10-10, into a timestamp with time zone.
Example: 2005-10-10T00:00:00.000-04:00
There's a DB2 function TO_UTC_TIMESTAMP; however, that function isn't available in z/os.
Does anyone know of a way to do this in Db2 for z/OS?