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 +
SQL0401N The data types of the operands for the operation "=" are not
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.