title: How do I get data between midnight today and NOW?
body: <p>As the title suggests, I'm simply trying to get the result set between midnight today and right now. So given the time of this post, I want data between 06/30/16 00:00:00 and 06/30/16 15:52:00. Why does the below query not return anything? Thanks.</p>
  
  <pre><code>SELECT * FROM tableName
  WHERE event_date &gt;= TO_DATE(TRUNC(SYSDATE) || ' 00:00:00', 'DD-MON-YY HH24:MI:SS')
  AND event_date &lt;= TO_DATE(TRUNC(SYSDATE))
  </code></pre>