title: Named parameter not bound : DATE_FORMAT Native Query in Spring Boot
body: <p>I am trying to get table data as list using select query between dateFrom and current date using MySQL Native Query in Spring Boot. and MySQL database field datatype is String.</p>
  <p>Below is Query in Repository:</p>
  <pre><code>@Query(value = &quot;select * from Account where DATETIMESTAMP &gt;= :dateFrom  AND DATETIMESTAMP &lt; :DATE_FORMAT(curdate(), '%d/%m/%Y')&quot;, nativeQuery = true)
  List&lt;Account&gt; findByDate(@Param(&quot;dateFrom&quot;) String dateFrom);
  </code></pre>
  <p>Getting below error for above query in Spring Boot:</p>
  <pre><code> Named parameter not bound : DATE_FORMAT; nested exception is org.hibernate.QueryException: Named parameter not bound : DATE_FORMAT
  </code></pre>
  <p>Can anyone please help me to frame the query for the same.</p>