Re: Problem with a date in the query !! (small example)

Hi Gab!

A small Example for you!
I hope it helps.

<SQL>
-- creating "some" Dates
CREATE OR REPLACE VIEW dat_test_vw
AS
SELECT TO_DATE (20040101,'yyyymmdd') + id datum
FROM (
         SELECT LEVEL id
         FROM  dual a
         where 1=1
         CONNECT BY LEVEL <= 10000
      );


-- selecting the intended period of time
SELECT a.*
FROM dat_test_vw a
,(SELECT to_date(TO_char(sysdate,'yyyy') || '0401','yyyymmdd') reference_date FROM dual) ref_dat
WHERE 1=1
AND ref_dat.reference_date <= a.datum
AND a.datum <= add_months(ref_dat.reference_date, +12) -1;
</SQL>

Merry Christmas and a happy new Year!

Bye!
Oli
.