title: have to get data from VISIT_Table filter with only date no time
body: <pre><code>SELECT * 
  FROM VISIT_Table 
  WHERE 
      ID='" + ID + "' AND 
      DATE ='" + DateTime.Now.ToString("yyyy-MM-dd") + @"'";
  </code></pre>
  
  <p>Above is my query I have to get data from <code>VISIT_Table</code> filter with only date no datetime..</p>
  
  <p>In database <code>visit_date</code> stores <code>2012-10-27 11:10:35</code> I have to get data with only date no time</p>