title: Convert DateTime into Date only, inside of the SELECT SQL statement
body: <p>I have an SQL statement</p>
  
  <pre><code>SELECT NO, MEMBID, DATEFROM, DATETO from Member where MEMBID ='xxyy'
  </code></pre>
  
  <p>I get a return where the dates are in DateTime format. I only want them to be in Date format.</p>
  
  <p>I have tried:-</p>
  
  <pre><code>SELECT NO, MEMBID, CONVERT(DATEFROM, GETDATE()), DATETO from Member where MEMBID ='xxyy'
  
  SELECT NO, MEMBID, CAST(DATEFROM as DATE()), DATETO from Member where MEMBID ='xxyy'
  </code></pre>
  
  <p>these don't seem to be working.</p>
  
  <p>I need to convert inside the SQL Statement itself. Been looking around on Google but can't seem to find anything. Any insights?</p>
  
  <p><strong>EDIT :-</strong>
  What finally worked for me is the following conversion technique.</p>
  
  <p>CONVERT(VARCHAR(10), DATEFROM, 101)</p>