oracle winter time change

Solutions on MaxInterview for oracle winter time change by the best coders in the world

Search
showing results for - "oracle winter time change"
Ian
06 Feb 2019
1ALTER SESSION SET NLS_LANGUAGE=english; -- First day of week
2SELECT 
3	NEXT_DAY(LAST_DAY(TO_DATE(TO_CHAR('01/10/' -- Last Sunday of October 02:00
4        || (EXTRACT(YEAR FROM SYSDATE)-5 + level) || '02:00:00'), 
5           'DD/MM/YYYY HH24:MI:SS')) - INTERVAL '7' DAY, 'SUNDAY') AS H_WINTER,
6	NEXT_DAY(LAST_DAY(TO_DATE(TO_CHAR('01/03/' -- Last Sunday of March 02:00 
7		|| (EXTRACT(YEAR FROM SYSDATE)-5 + level) || '02:00:00'),
8		'DD/MM/YYYY HH24:MI:SS')) - INTERVAL '7' DAY, 'SUNDAY') AS H_SUMMER
9FROM DUAL CONNECT BY level <=10;
10-- ⇓ Test it ⇓ (Fiddle source link)
similar questions
oracle first day of last yearoracle to dateoracle add time to dateoracle list dates without weekendsoracle apex warn on unsaved changeschange date format in oracle querychange compatible parameter in oracle 12cspecific date format oracleoracle sql date summer timeoracle last day of monthoracle set date formatoracle alter sequence restart start withcurrent year sql oracleoracle current date without timeoracle sql day of month from dateoracle exchange partitionupdate oracleoracle apex update memberoracle sql date winter timeoracle default date formatchange table name apex oracleoracle add months to sysdateoracle current dateoracle session date formatoracle date summer timeto date oracle with timeoracle date winter time
queries leading to this page
oracle winter time changeoracle winter time change