select
    q.date 
from  q
where q.date between to_date($P{DATE_FROM},'DD/MM/YYYY') and to_date($P{DATE_TO},'DD/MM/YYYY')

select
	qsd.date,
from table1 qsd
  inner join table2 q on q.pk = qsd.fk
  inner join table3 cc on q.pk = cc.fk
  inner join table4 cq on cq.pk = cc.fk
  inner join table5 on qsd.fk = s.pk
where q.date between to_date($P{DATE_FROM},'DD/MM/YYYY') and to_date($P{DATE_TO},'DD/MM/YYYY')

  Filling report...
  Locale: English (United States)
  Time zone: Default
Error filling print... Error executing SQL statement for : test_report 
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : test_report       at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:229)      at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:758)      at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:623)      at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1160)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:802)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:746)      at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)      at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:879)      at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)      at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)  Caused by: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got -       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051)      at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156)      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415)      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3460)      at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:222)      ... 11 more  
Print not filled. Try to use an EmptyDataSource...

ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []