title: How to group by date without time-stamp in hibernate query language?
body: <p>I want to get data from a table that is grouped by date, but since my date column data type is datetime. </p>
  
  <pre><code>"select to_char(datePerformed, 'yyyy-mm-dd'), sum(sendAmount) from AppTransaction group by to_char(datePerformed, 'yyyy-mm-dd')"
  </code></pre>
  
  <p>since datePerformed with time-stamp, its group with including the time stamp, so i have used above query with </p>
  
  <pre><code>group by to_char(datePerformed, 'yyyy-mm-dd')"
  </code></pre>
  
  <p>I'm getting an exception like this,</p>
  
  <pre><code>java.lang.IllegalArgumentException: Cannot format given Object as a Date
  </code></pre>
  
  <p>I want this query to be group my data set with data without time-stamp, how can I do it?</p>