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

0 vote319 views1 answer
Postgres create database if not exists
SQL
0 vote347 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote331 views1 answer
Mysql:5.6 syntax create table
SQL
4 votes337 views1 answer
To date oracle with time
SQL
0 vote343 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote338 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote328 views1 answer
MySql count occurences more than"
SQL
4 votes439 views4 answers
Remove duplicate old value in mysql
SQL
2 votes337 views2 answers
Join update query in sql
SQL
4 votes424 views1 answer
Oracle table statistics
SQL