title: SQL query to select data between two dates and times
body: <p>There is a <code>[time]</code> field in my table, which is a DateTime variable, the format just like <code>2014-04-08 23:55:00.000</code>. I want to select all the records between two specific dates and times.</p>
  <p>such like this:</p>
  <pre><code>SELECT * FROM  [table] 
  WHERE time &gt;=2014-04-08 23:53:00.000 AND time &lt;= 2014-04-08 23:58:00.000
  </code></pre>
  <p>I write a SQL</p>
  <pre><code>SELECT * FROM [table]
  WHERE time BETWEEN #4/19/2014 12:00:00 AM# and #4/19/2014 12:30:00 AM#
  </code></pre>
  <p>But this doesn't work. Error code is:</p>
  <blockquote>
  <p>Incorrect syntax near '12'.</p>
  <p>Description: An unhandled exception occurred during the execution of
  the current web request. Please review the stack trace for more
  information about the error and where it originated in the code.</p>
  </blockquote>