Hi,

I've looked through all the date functions in the forum but I didn't see anything where days are being added to a date/timestamp. I want to select rows from a table where the date is current date + or - 3 days but the date data type in the table is a datetimestamp so I get the following error

db2 => select startdate from table1 where startdate = current date +
3 days
SQL0401N The data types of the operands for the operation "=" are not
compatible. SQLSTATE=42818

Any help will be appreciated.
Thanks

Well, the error message says it all: you either need to cast the result of your expression (current date + 3 days) as a timestamp or compare it with the date portion of the timestamp. I'd choose the former.