Skip to Content
0
Jun 08, 2022 at 12:39 PM

future CET timezone conversion

33 Views

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

image.png

How come?
Regards
LB

Attachments

image.png (5.4 kB)