Oracle 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 vote172 views1 answer
How to move a columns location in mysql
SQL
5 votes167 views1 answer
List foreign key oracle
SQL
2 votes182 views1 answer
How to make insert script from table in SQL server
SQL
16 votes234 views3 answers
Order by sql query
SQL
22 votes161 views2 answers
Mysql show all tables
SQL
10 votes166 views5 answers
Mysql create user
SQL
50 votes272 views6 answers
Install mysql on ubuntu
SQL
0 vote306 views1 answer
Provera dupliranih konatakata
SQL
0 vote181 views1 answer
Date on SQL
SQL
1 vote167 views1 answer
Funzioni plsql
SQL