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

16 votes281 views1 answer
CTE statement sql server
SQL
1 vote296 views1 answer
DATE_SUB postgres
SQL
0 vote292 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote311 views1 answer
Shortcut run sql pgadmin
SQL
0 vote581 views1 answer
How to connect .sql data set to powerbi
SQL
8 votes284 views3 answers
Mysql alter table add index
SQL
22 votes319 views3 answers
Year format in date mysql
SQL
0 vote296 views1 answer
SQL SELECT-Klausel
SQL
0 vote296 views1 answer
Enable full text search mysql
SQL
0 vote351 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL