How to transform DB date format for parameter class java.util.date

[evan.warrick]

My DB date format example:     2021-09-01 14:52:00.157

I'm using 2 parameters in report both with Parameter Class = java.util.Date

Parameter1 = Date Range From 

Parameter2 = Date Range To

How do I configure iReport to handle my DB date format?

My report query:

select * from CN_Log
inner join Item_Staging
on CN_Log.CN_PK1 = Item_Staging.Item_Number
where CN_PK1 = '5VX740'
and CN_Change_ID = '595448'
and Last_Updated >= $P{Date Range From}
and Last_Updated <= $P{Date Range To}

[luked]

Have you tried converting your date format in your SQL query?

I use the below in Oracle -

cast(iuv.time_out as date) betwen to_date($P{START DATE}, 'YYYYMMDD') and to_date($P{END DATE}, 'YYYYMMDD')