title: Handling date in SQL Server
body: <p>I am working on a website in asp.net. I am getting a date from a web page and then depending on the user input I want to get results from SQL Server database (using stored procedures). </p>
  
  <p>Problem is that I am getting date only from UI in this format <code>2016-10-08</code> which is of type string. But in the database, I have a column which is of type <code>datetime</code> in this format <code>2016-10-08 17:38:00.000</code>.</p>
  
  <p>I am using this query to search but it does not work.</p>
  
  <pre><code>select * 
  from table 
  where acceptedDate like @sDate+ '%';
  </code></pre>
  
  <p>where <code>sDate</code> is input parameter for stored procedure. Please help. thanks</p>