oracle sql winter time change

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

Search
showing results for - "oracle sql winter time change"
Erika
21 Apr 2017
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
change date format in oracle queryoracle alter sequenceoracle add months to sysdateupdate oracleoracle sql date winter timeoracle sql day of month from dateupdate table syntax in oracleoracle date winter timeoracle sql date summer timeupdate from select oraclechange compatible parameter in oracle 12coracle session date formatoracle apex update membersql trigger oracle updateoracle sql updatepl sql trigger update sysdateoracle change expired password sql developeroracle update withsql update trigger only when column is modifiedoracle default date formatchange table name apex oracleoracle alter sequence restart start withalter sequence set current value oracleoracle set date formatoracle date summer timeoracle current date without time
queries leading to this page
oracle winter time changeoracle sql winter time change