cancel
Showing results for 
Search instead for 
Did you mean: 

future CET timezone conversion

former_member749991
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (0)