Oracle date winter 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

40 votes178 views4 answers
PostgreSQL add column
SQL
0 vote106 views1 answer
Set root password mysql xampp
SQL
0 vote102 views1 answer
Procedures sql insert mysql
SQL
0 vote132 views2 answers
Search stored procedures by name
SQL
0 vote122 views1 answer
How to combine rows in sql server procedure
SQL
8 votes125 views4 answers
Reset SQL auto increment
SQL
1 vote115 views1 answer
How to truncate a table in databse
SQL
16 votes142 views6 answers
Mysql find duplicates in same table
SQL
0 vote106 views1 answer
Systemverilog unique constraint unique values
SQL
13 votes123 views2 answers
Sql join 3 tables
SQL