How to add one day to a Date Parameter

[tanatpan_w]

I used PostgreSQL in the past. And I'm creating a Jasper report that includes the following parameters:

• DATESTART (Date)

Example : PostgreSQL Query

select * from TB1 where A >= $P{DATESTART} and A < $P{DATESTART} + 1 day

Is there any way to do something similar in Jasper Reports (PostgreSQL)?

 

[tanatpan_w]

select * from TB1 where A >= $P{DATESTART} and A < $P{DATESTART} + INTERVAL '1 Day' 

[tanatpan_w]

select * from TB1 where A >= $P{DATESTART} and A < to_date($P{DATESTART},'yyyy-MM-dd') + INTERVAL '1 Day'