using date input parameter in SQL where clause

[viewireport]

DB - postgres

 

SELECT tt.created_date

FROM

test_table tt

WHERE 

DATE(uc.created_stamp) = DATE($P{ic_date})

 

Here, ic_date is a parameter created using ireport.

parameter (ic_date) class is java.util.Date

 

If default value expression is required, enter like this,

new SimpleDateFormat("yyyy-MM-dd").parse("2008-01-01")

 

Hope this will help many since it took some time for me to figure out the same.