Oracle sql winter time change

ALTER SESSION SET NLS_LANGUAGE=english; -- First day of week
SELECT 
	NEXT_DAY(LAST_DAY(TO_DATE(TO_CHAR('01/10/' -- Last Sunday of October 02:00
        || (EXTRACT(YEAR FROM SYSDATE)-5 + level) || '02:00:00'), 
           'DD/MM/YYYY HH24:MI:SS')) - INTERVAL '7' DAY, 'SUNDAY') AS H_WINTER,
	NEXT_DAY(LAST_DAY(TO_DATE(TO_CHAR('01/03/' -- Last Sunday of March 02:00 
		|| (EXTRACT(YEAR FROM SYSDATE)-5 + level) || '02:00:00'),
		'DD/MM/YYYY HH24:MI:SS')) - INTERVAL '7' DAY, 'SUNDAY') AS H_SUMMER
FROM DUAL CONNECT BY level <=10;
-- ⇓ Test it ⇓ (Fiddle source link)

Similar codes

3 votes336 views1 answer
Oracle rollback
SQL
0 vote338 views1 answer
Postgres declare variable
SQL
0 vote336 views1 answer
Database timezone
SQL
0 vote354 views1 answer
Sql add calculated column
SQL
2 votes352 views1 answer
Set column to not null mysql
SQL
17 votes352 views6 answers
Current date in sql
SQL
6 votes397 views2 answers
How to get last element sql
SQL
12 votes338 views2 answers
Delete entries in postgresql
SQL
38 votes394 views6 answers
Alter table mysql
SQL
17 votes347 views3 answers
Cast in sql server
SQL