Hello dear community,
I have the following select to build a calendar table:
select *
from (SELECT ((TRUNC(CURRENT_TIMESTAMP )-365) + NUMTODSINTERVAL(60*LEVEL,'MINUTE') ) AS tag
FROM DUAL connect by level <= 10000)
where trunc(tag) = '28.03.2021';
But on March 28th, 2021 it should only be 23 hours due to the time change in germany.
Does anyone have a solution for the problem?