2023 Apr 29 9:57 AM
DATA: dat TYPE d,
tim TYPE t,
lv_utc_tstmp TYPE timestamp.
dat = '20230428'.
tim = '005954'.
CONVERT DATE dat TIME tim DAYLIGHT SAVING TIME 'X'
INTO TIME STAMP DATA(lv_utc_tstmp2) TIME ZONE 'EGYPT'.
cl_demo_output=>write_data( lv_utc_tstmp2 ).
I am trying to convert time from EGYPT to UTC.
When the time between 12:00:00 AM to 12:59:59AM, the returned value in lv_utc_tstmp2 is 0.
Can any one help me to solve this problem?
2023 Apr 29 12:41 PM
Please edit your question, select your code and press the button [CODE], which makes the code appear colored/indented, it will be easier for people to look at it. Thank you!
2023 Apr 29 5:27 PM
Is EGYPT set up as a valid time zone on your system? Perhaps EGY would work? Egypt Standard Time?
2023 Apr 29 5:31 PM
EGYPT is our active time zone on the system.
I tried to used EGY but it gave me the same of EGYPT "0"
2023 May 02 10:34 AM
AFAIK Egypt switched back to DST last Friday in April at 00:00 UTC+2:00, so those date/time don't exist.