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

9 votes213 views2 answers
Mysql change value
SQL
0 vote244 views1 answer
How to set up an anonymous function to variable in swift
SQL
10 votes170 views2 answers
Django mysql
SQL
10 votes220 views3 answers
Sql select between two dates
SQL
0 vote216 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote220 views1 answer
Rename constraint postgresql
SQL
13 votes238 views4 answers
What is sql
SQL
1 vote218 views1 answer
Sql server 2016 reseed identity
SQL
0 vote263 views1 answer
Copy from one table to another postgres using matching column
SQL
2 votes218 views1 answer
Postgresql drop primary key constraint
SQL