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 Received on Tue Dec 27 2005 - 04:43:51 CST