Problem by using dates as parameter in my Jasper Server


Hi Jasper fans,

on my jasperserver, i have a report with two date ( parameters (StartDate, EndDate). I want to execute the report by using the rest-interface

I want to pass the date with the time-information: like StartDate=1997-01-01T04:05:06+02:00 with my rest-interface.

Unfortunately, the report shows the StartDate with format: DATEFORMAT($P{StartDate},"yyyy-MM-dd HH:mm:ss")  = 1997-01-01 00:00:00

So, the time information is gone. Any advice to receive the time information?

Kind Regards Florian

florian.johannssen_1's picture
Joined: Sep 1 2017 - 3:33am
Last seen: 2 years 7 months ago

1 Answer:


Witch database you are using?
I think you need to use database string to date function both side parameter and database filed this is the best option for resolving it,

mca.amitrami's picture
Joined: Jun 11 2018 - 4:58am
Last seen: 7 months 2 weeks ago