Hi,
i am getting some odd behaviour from hana cloud LOCALTOUTC function with timezone CET.
In 2022 the setting 'CET' considers summertime CEST, in 2040 not.
I looked it up for the last Sunday in March of both years, when time is set from 3am CET to 2am CEST.
select 1 as id, localtoutc(to_seconddate('20220327 0200','YYYYMMDD HH24MI'),'CET') as utc2022, localtoutc(to_seconddate('20400325 0200','YYYYMMDD HH24MI'),'CET') as utc2040 from dummy union all select 2 as id, localtoutc(to_seconddate('20220327 0300','YYYYMMDD HH24MI'),'CET') as utc2022, localtoutc(to_seconddate('20400325 0300','YYYYMMDD HH24MI'),'CET') as utc2040 from dummy order by id
How come?
Regards
LB