title: Date Range in PL/SQL (Oracle)
body: <p>If I have table with a Date column called <code>myDate</code>, with values like <code>2009-08-25 09:00:09.0</code>. </p>
  
  <p>I want to select all rows for <em>Aug 25</em>, from <em>12:00:01 AM</em> until <em>11:59:59 PM</em> and NOTHING for <em>Aug 26</em>. Is it sufficient to simply use the condition:</p>
  
  <pre><code>where myDate between Date '2009-08-25' and Date '2009-08-26'
  </code></pre>
  
  <p>And I want to select all rows BEFORE <em>Aug 25</em>, not including Aug 25. Can I do:</p>
  
  <pre><code>where myDate &lt; Date '2009-08-25'
  </code></pre>