title: How do I group by date and not have the time being a factor?
body: <p>My DateCompleted return the date and the time. If I would like to group just by the date and ignore the time. How would I go about this?</p>
  
  <pre><code>SELECT  
    Cast(Jobs.DateCompleted AS VarChar) AS 'DateCompleted',
    SUM(Metrics.GB) AS GB, 
    SUM(Metrics.KB) AS KB
  FROM Metrics 
  INNER JOIN Jobs ON Jobs.JobId = Metrics.JobId 
  INNER JOIN Projects ON Projects.ProjectId = Jobs.ProjectId 
  INNER JOIN JobTypes ON JobTypes.JobTypeId = Jobs.JobTypeId
  WHERE Jobs.DateCompleted BETWEEN '12/01/2012' AND '12/03/2012' 
  GROUP BY Jobs.DateCompleted
  </code></pre>