Analytics Software

Hi,
I have a report with date filter selected from a calendar. But in the database data is present with time stamp. When i'm filtering with date it's not fetching any record due to time mismatch. I tried with cast function but it did not solve my problem.

Obiee fires query with

it's part of my report query

select distinct  cast(T11983.END_DT as DATE) as c1,
                          cast(( T11983.END_DT + -7 ) as DATE) as c2,
                          cast(ADD_MONTHS(T11983.END_DT, -1) as DATE) as c3,
                          cast(ADD_MONTHS(T11983.END_DT, -12) as DATE) as c4
                    from 
                         KDD_REVIEW T90,
                         KDD_REVIEW_OWNER T156,
                         KDD_ACTIVITY T11983
                    where  ( T90.CLS_ACTVY_TYPE_CD = T11983.ACTVY_TYPE_CD and T90.CLS_ID = T156.OWNER_SEQ_ID and T90.REVIEW_ID = T11983.REVIEW_ID and T90.REVIEW_TYPE_CD = 'AL' and T90.STATUS_CD = 'CL' and T11983.END_DT = TIMESTAMP '2008-12-24 00:00:00' ) 



--- T11983.END_DT = TIMESTAMP '2008-12-24 00:00:00'  this condition is failing ,      

Please help if anyone knows ...