jinwei.si

On the other hand, the query works when I use "CREATED <= CURRENT_DATE + 3 DAYS" Only non-functional when I use the time operation with the parameter

Hi, I need to query the dataset between selected parameters ${startDate} and ${endDate}. However, the result should contain all the data from the last date as well (until the 24 o clock at endDate instead of 0 o clock). So I tried to change the query to (I am using DB2): select * from HWE.TRANSACTIONSwhere CREATED >= $P{startDate} AND CREATED <= $P{endDate} + 1 days It gives an error message that the SQL query isn't correct.I have tried to create a new parameter, that didn't work either. Thank you.