1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| WITH DATA AS (
SELECT to_date('01/01/2012', 'DD/MM/YYYY') As date_debut, to_date('06/06/2012', 'DD/MM/YYYY') As date_fin FROM DUAL UNION
SELECT to_date('31/08/2011', 'DD/MM/YYYY') As date_debut, to_date('12/06/2012', 'DD/MM/YYYY') As date_fin FROM DUAL UNION
SELECT to_date('31/01/2012', 'DD/MM/YYYY') As date_debut, to_date('02/02/2012', 'DD/MM/YYYY') As date_fin FROM DUAL UNION
SELECT to_date('01/12/2011', 'DD/MM/YYYY') As date_debut, to_date('31/12/2012', 'DD/MM/YYYY') As date_fin FROM DUAL UNION
SELECT to_date('02/02/2012', 'DD/MM/YYYY') As date_debut, to_date('31/12/2012', 'DD/MM/YYYY') As date_fin FROM DUAL
)
SELECT * FROM DATA
WHERE date_debut <= to_date('31/01/2012', 'DD/MM/YYYY') AND date_fin >= to_date('01/01/2012', 'DD/MM/YYYY');
DATE_DEBUT DATE_FIN
------------------------- -------------------------
31/08/11 00:00:00 12/06/12 00:00:00
01/12/11 00:00:00 31/12/12 00:00:00
01/01/12 00:00:00 06/06/12 00:00:00
31/01/12 00:00:00 02/02/12 00:00:00
WITH DATA AS (
SELECT to_date('01/01/2012', 'DD/MM/YYYY') As date_debut, to_date('06/06/2012', 'DD/MM/YYYY') As date_fin FROM DUAL UNION
SELECT to_date('31/08/2011', 'DD/MM/YYYY') As date_debut, to_date('12/06/2012', 'DD/MM/YYYY') As date_fin FROM DUAL UNION
SELECT to_date('31/01/2012', 'DD/MM/YYYY') As date_debut, to_date('02/02/2012', 'DD/MM/YYYY') As date_fin FROM DUAL UNION
SELECT to_date('01/12/2011', 'DD/MM/YYYY') As date_debut, to_date('31/12/2012', 'DD/MM/YYYY') As date_fin FROM DUAL UNION
SELECT to_date('02/02/2012', 'DD/MM/YYYY') As date_debut, to_date('31/12/2012', 'DD/MM/YYYY') As date_fin FROM DUAL
)
SELECT * FROM DATA
WHERE (date_debut <= to_date('01/01/2012', 'DD/MM/YYYY') AND date_fin >= to_date('01/01/2012', 'DD/MM/YYYY') )
OR (date_debut BETWEEN to_date('01/01/2012', 'DD/MM/YYYY') AND to_date('31/01/2012', 'DD/MM/YYYY') )
OR ( date_fin BETWEEN to_date('01/01/2012', 'DD/MM/YYYY') AND to_date('31/01/2012', 'DD/MM/YYYY') );
DATE_DEBUT DATE_FIN
------------------------- -------------------------
31/08/11 00:00:00 12/06/12 00:00:00
01/12/11 00:00:00 31/12/12 00:00:00
01/01/12 00:00:00 06/06/12 00:00:00
31/01/12 00:00:00 02/02/12 00:00:00 |
Partager