Oracle sql winter time change

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

Similar codes

0 vote353 views1 answer
Sql cmd no truncate
SQL
0 vote317 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote367 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote349 views1 answer
Proc sql not in working
SQL
0 vote365 views1 answer
Sql query to force the database to be drop
SQL
16 votes342 views4 answers
Sort by sql
SQL
0 vote341 views1 answer
Oracle sql log to console
SQL
0 vote331 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
2 votes336 views1 answer
Pandas to sql index
SQL
0 vote348 views1 answer
With_for_update sqlalchemy
SQL