title: Hibernate: sorting data by date & time
body: <p>In mysql database I have a table named <code>bug_list</code></p>
  
  <pre><code>tables name: bug_list
  
  id    projectId    created_date  
  1     5            2012-06-30 13:30:57  
  2     5            2012-07-30 10:30:58  
  3     5            2012-07-30 12:30:44  
  4     5            2012-07-31 13:30:14  
  5     5            2012-07-31 14:30:32 
  </code></pre>
  
  <p>I want to sort it by month (like jan, feb... ) in the first result,<br>
  sort it by week day (like mon, tue, wed) in the second result<br>
  and sort it by hour (like 2hrs range say 8-10am, 10-12pm....) in the third result  </p>
  
  <p>I can't understand from criteria query. Can somebody explain how to resolve this issue? </p>