Horje
oracle sql date summer time Code Example
oracle sql date summer time 
ALTER SESSION SET NLS_LANGUAGE=english; -- First day of week
SELECT
	-- Last Sunday of October at 02:00
	NEXT_DAY(LAST_DAY(TO_DATE(TO_CHAR('01/10/' 
        || (EXTRACT(YEAR FROM SYSDATE)-5 + level) || '02:00:00'), 
           'DD/MM/YYYY HH24:MI:SS')) - INTERVAL '7' DAY, 'SUNDAY') AS H_WINTER,
	-- Last Sunday of March at 02:00 (missing hour)
	NEXT_DAY(LAST_DAY(TO_DATE(TO_CHAR('01/03/' 
		|| (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;



Sql

Related
TSQL Code Snippet For Optimized Sales Query Code Example TSQL Code Snippet For Optimized Sales Query Code Example
mysql - find in comma separated string of values Code Example mysql - find in comma separated string of values Code Example
how to check table in postgresql from terminal Code Example how to check table in postgresql from terminal Code Example
sql email regex Code Example sql email regex Code Example
change from not null postgresql Code Example change from not null postgresql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 8



 

Horje