title: Simple Oracle SQL date syntax question
body: <p>I am trying to convert a working MS Access query to run on an Oracle database being accessed via VB Script (.asp). This is the last section of the WHERE clause:</p>
  
  <pre><code>sql = sql &amp; "WHERE (UAT.HB.MB_MODE = 'A' AND   UAT.HB.PRINT_DATE &gt;= '" 
  &amp; SD &amp; "' AND UAT.HB.PRINT_DATE &lt;= '" &amp; ED  &amp;"'  )"
  </code></pre>
  
  <p>The variable "SD" (i.e. "start date") is a text string that can contain a value such as "11/11/2008". The same goes for the variable "ED" (i.e. "end date").</p>
  
  <p>However, the dates do not work. Does Oracle require a special way to use dates?</p>
  
  <p>Do the dates have to be converted? Do I surround them with the '#' keyword like you would in MS Access?</p>