title: Distinct DateTime field without Time in HQL
body: <p>I'm trying to select Distinct DateTime field in HQL.</p>
  
  <pre><code>select distinct CreatedDate from ClaimFile order by CreatedDate DESC
  </code></pre>
  
  <p>Any Idea how can I get distinct dates without time. right now it can't be distinct with time.</p>
  
  <p>Thanks</p>