title: dateadd function is not working in Hibbernate
body: <p>I want to get previous days data from my database and for that I have added a <code>DATE_ADD</code> function in my hibernate query using MySQL Database but I am getting error while running the query and here the query is: </p>
  
  <pre><code>select columnname 
  from tablename 
  where columnname = DATE_ADD(day,-1,getDate())
  </code></pre>