tanatpan_w
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by tanatpan_w
-
-
select * from TB1 where A >= $P{DATESTART} and A < $P{DATESTART} + INTERVAL '1 Day'
-
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)?
How to add one day to a Date Parameter
in Products
Posted
select * from TB1 where A >= $P{DATESTART} and A < to_date($P{DATESTART},'yyyy-MM-dd') + INTERVAL '1 Day'