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 vote132 views1 answer
Mysql a from on this page has
SQL
9 votes125 views4 answers
SQL Date Format
SQL
3 votes137 views1 answer
Locate sql server
SQL
0 vote129 views1 answer
Add sqlite3 in lumen
SQL
1 vote148 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote143 views1 answer
Add SuperUser MySQL
SQL
0 vote140 views1 answer
Check for directory in bash
SQL
1 vote179 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote125 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
0 vote122 views1 answer
Psql datestyle
SQL