iReport Timestamp question

[ktr944]

I'm new to Jaspersoft, and would appreciate if someone can help me.

I've a database field which is in datetime format YYYY-MM-DD HH:MM:SS. I want to create an iReport with date as the parameter (choosing a Date from the calendar), but still want to pass YYYY-MM-DD HH:MM:SS to the SQL query.

 

 

 

[hishamkmr]

creat a parameter in ireport with type java.sql.time

in query use it by formating with to_date function

eg: - date_from is the parameter with data type java.sql.time

query will be

select name from 

employee

where joining_date <= to_date($P{date_from},'dd/MM/yyyy HH:MI:SS)

hope this will help..let me know the result..