title: Insert date only into database
body: <p>I am trying to save only date (ex: <code>2011/09/26 00:00:00</code>) from <code>getdate()</code>. I am using sql server 2005.</p>
  
  <p>My sql query is going to be like this:</p>
  
  <pre><code>Insert into Merchant(startdate) 
  values **today's date only**
  </code></pre>
  
  <p>How is it possible?</p>