I want the query results to be grouped by day of the week .. like into 7 groups Monday, Tuesday, Wednesday... etc one for each
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.
How do I mplement this query with HQL/criteria?
Is there a built in clause like this that I can use in Hibernate (HQL/Criteria)?
Thanks in advance.
Try this one:
select dayofweek(dateField), count(*)
from PersistentClass
group by 1