title: Date/Time Input Parameters
body: <p>I am using two <strong>date time</strong> parameters in the report. When I use the same parameters in the query, no results are shown. Moreover if I use <strong>date</strong> parameters then the results are shown but not all records are shown.</p>
  
  <p>I also executed the same query (with date time) in <em>MySQL</em> and the results are shown, I think there is no mistake in the query. </p>
  
  <p>I tried many things. The query is some what like :</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM abc WHERE datetime BETWEEN 
    date_format($P{fromdate}, '%d-%c-%y 00:00:00') 
    AND date_format($P{todate}, '%d-%c-%y 23:59:59')
  </code></pre>