"Lennart" <Erik.Lennart.Jonsson@gmail.com> wrote in message
news:d23aed7d-34fd-4823-a3b8-7377e7a7508c@e6g2000prf.googlegroups.com...
> I assume CMPL_Q_DT is a timestamp. Try:
>
> [...]
> AND date(CMPL_Q_DT) > '2008-03-01';
>
> /Lennart

For performance reasons (in certain situations), you might want to try this:

AND date(CMPL_Q_DT) > '2008-03-01 00:00:00.000000' ;

date(CMPL_Q_DT) might prevent DB2 from using an index on that column.