I need to retreive all records for todays date something like this

select *
from TABLEa
where A = ??


So A should match all data for todays date and ignore all time data

What do you know about date/time/timestamp calculations on DB2?

Did you read this article?
DB2 Basics: Fun with Dates and Times

What did you tried? What result(or error) did you got from the trial?

I'm totally from sybase dont know much on db2
I tried this and it works
where DATE(COLUMNA) = DATE('2009-11-28')

also for current date

where DATE(COLUMNA) = DATE(current date)

but how do i get a previous date record say something like this

DATE(current date) - 1

Try:

current date - 1 DAY



there is no need to use DATE() with current date

Yeah this worked.Still learning DB2 ;-)