title: can we group by day of the week using hibernate?
body: <p>I want the query results to be grouped by day of the week .. like into 7 groups Monday, Tuesday, Wednesday... etc one for each</p>
  
  <p>the column in the table is a timestamp field like 12-Mar-2011 .....
  so I don't care which dates exist in the table I just need to get 7 groupings and if there is a count column which doesnt exist for like thursday it should return 0 and for wednesday the count should the total counts for all wednesday and like wise for each day of the week.</p>
  
  <p>How do I mplement this query with HQL/criteria?</p>
  
  <p>Is there a built in clause like this that I can use in Hibernate (HQL/Criteria)?</p>
  
  <p>Thanks in advance.</p>