title: How to get only the date(mm/dd/yyyy) by using the GETDATE()?
body: <p>Hello everyone I want to pick the current date of the system by using:</p>
  
  <p>Select GETDATE()</p>
  
  <p>It will give you the result</p>
  
  <p><strong>04/17/2013 06:37:35</strong></p>
  
  <p>But I just want <strong>04/17/2013</strong>. Because I don't need the time.</p>
  
  <p>Can anyone please help. Thanks in advance. </p>