title: How to select only date part from SQL Server CE datetime column?
body: <p>I am using SQL Server CE database and C# language. I have a table with a <code>datetime</code> type column. I want to use a SELECT statement like</p>
  
  <pre><code> SELECT * FROM Data WHERE Date = @Date
  </code></pre>
  
  <p>But I need only date part of the <code>datetime</code> value. So I can add parameter like </p>
  
  <pre><code> SQLCmd.Parameters.Add("@Date", date.Date);
  </code></pre>
  
  <p>My problem is with <code>SELECT</code> statement I think. </p>