Oracle sql date summer time

ALTER SESSION SET NLS_LANGUAGE=english; -- First day of week
SELECT
	-- Last Sunday of October at 02:00
	NEXT_DAY(LAST_DAY(TO_DATE(TO_CHAR('01/10/' 
        || (EXTRACT(YEAR FROM SYSDATE)-5 + level) || '02:00:00'), 
           'DD/MM/YYYY HH24:MI:SS')) - INTERVAL '7' DAY, 'SUNDAY') AS H_WINTER,
	-- Last Sunday of March at 02:00 (missing hour)
	NEXT_DAY(LAST_DAY(TO_DATE(TO_CHAR('01/03/' 
		|| (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;

Similar codes

4 votes156 views3 answers
Count with where
SQL
1 vote146 views1 answer
Sql group by error
SQL
2 votes153 views2 answers
Sqlite_busy: database is locked
SQL
3 votes153 views1 answer
Mysql insert on dupèlicate
SQL
1 vote132 views1 answer
Firebase bigquery cloud message
SQL
3 votes145 views2 answers
Oracle sql drop sequence
SQL
0 vote156 views2 answers
Sql trigger difference between for and after
SQL
24 votes139 views2 answers
Alter table delete column
SQL
0 vote101 views1 answer
How to get last client id sql
SQL
5 votes167 views4 answers
Traduction
SQL