title: date alternative in sql server
body: <pre><code>SELECT DATE(mbTimestamp_dt) As datefield1
  </code></pre>
  
  <p>The above DATE function works fine in MySQL 5.5 however, it doesn't work in SQL Server 2008.</p>
  
  <p>Here mbTimestamp_dt is in the following format : 2014-01-13 16:53:44</p>
  
  <p>What is the alternative for using DATE function in SQL Server 2008?</p>