title: Generate DATE value alone in SQL Server
body: <p>I have a query with a column <code>received</code> and the value <code>2014-02-13 19:34:00</code>. I fetch the date alone using <code>DATE(received)</code> and value is <code>2014-02-13</code></p>
  
  <p>In MySQL I use the following query:</p>
  
  <pre><code>SELECT DATE(received) AS Mydate, status  
  FROM Notification
  WHERE project = 'proj001'  
  GROUP BY Mydate 
  ORDER BY received;
  </code></pre>
  
  <p>How to generate same value in SQL Server?</p>