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

6 votes319 views1 answer
What is where clause in sql
SQL
0 vote341 views1 answer
Sql sum if
SQL
5 votes372 views1 answer
Oracle source query
SQL
0 vote330 views1 answer
Table or view does not exist
SQL
4 votes326 views3 answers
How to describe a table in sqlite3
SQL
0 vote347 views1 answer
Migration graphql
SQL
8 votes313 views1 answer
Mysql restore database
SQL
0 vote359 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
6 votes348 views2 answers
Mysqldump password in file
SQL
1 vote319 views1 answer
Raw query must include primary key
SQL