title: inserting only date in a column in sql server
body: <p>Is there a way to insert only date in a datetime column in sql server without the time?
  for example</p>
  
  <blockquote>
    <p>date (datetime)</p>
    
    <p>===============</p>
    
    <p>12-01-2000</p>
    
    <p>16-02-2000</p>
  </blockquote>
  
  <p>or i should store this as a varchar and <strong>cast</strong> it when retriving so that i can convert to whatever form i need.</p>