title: JPA and Sysdate issue - forcefully accepting Double data types
body: <p>I am using Spring Data JPA and developed below query which will dynamically take the day values and fetch data, but looks like its arguable looking for Double data type. Any reason why its taking double?</p>
  <pre><code>@Query(&quot;SELECT new com.XXX.SomeDTODto(p.visitDate, ..........) &quot;
          + &quot;FROM PatientData p &quot;
          + &quot;INNER JOIN ................. &quot;
          + &quot;INNER JOIN .................&quot;
          + &quot;INNER JOIN .................. &quot;
          + &quot;INNER ..... &quot;
          + &quot;WHERE (TRUNC (p.visitDate) &gt;= TRUNC (SYSDATE + :startDay) AND TRUNC (p.visitDate) &lt;= TRUNC (SYSDATE + :endDay))&quot;)
  Page&lt;SomeDTODto&gt; findByvisitDateBetweenDays(@Param(&quot;startDay&quot;) Double startDay,
                                                     @Param(&quot;endDay&quot;) Double endDay, Pageable pageable);
  </code></pre>
  <p>I am getting below, functional test cases runs against H2 DB and failing</p>
  <blockquote>
  <p>here TRUNC(patient0_.patient_dt)&gt;=TRUNC(SYSDATE+?) and TRUNC(patient0_.patient_dt)&lt;=TRUNC(SYSDATE+?) order by patient0_.patient_dt asc limit ? [50004-196]</p>
  </blockquote>