tet2neu emmerdeur | je viens de tester, ça marche très bien
Code :
- create table toto as select 1 COL1, to_date('01/01/2001','DD/MM/YYYY') d1, to_date('31/01/2001','DD/MM/YYYY') d2 from dual;
- insert into toto select 2 COL1, to_date('01/02/2001','DD/MM/YYYY') d1, to_date('28/02/2001','DD/MM/YYYY') d2 from dual;
- insert into toto select 3 COL1, to_date('01/07/2009','DD/MM/YYYY') d1, to_date('31/07/2009','DD/MM/YYYY') d2 from dual;
- select * from toto;
- 1 01/01/01 31/01/01
- 2 01/02/01 28/02/01
- 3 01/07/09 31/07/09
- select * from toto where sysdate between d1 and d2;
- 3 01/07/09 31/07/09
|
|