title: Hibernate Projection Group By Month
body: <p>I am Hibernate newbie and i have a working sql query which i try to re-write with Hibernate projections and restrictions. Everything is fine but when i want to group by my <code>time_stamp</code> column in <code>YYYY-MM</code> format i could not make it</p>
  
  <p>How do i use <code>sqlGroupProjection</code> of Hibernate for below GROUP BY clause</p>
  
  <blockquote>
    <p>group by to_char(view_date, 'YYYY-MM')</p>
  </blockquote>
  
  <p>Any help would be appreciated</p>