title: Querying datetime in oracle
body: <p>I have a date type column in a table, where I store date along with time.</p>
  
  <p>I want to query it by <code>WHERE</code> clause
  I did it this way:</p>
  
  <pre><code>select * 
  from conference_hall_book 
  where to_date(end_time,'dd/mon/yyyy hh24:mi:ss') &lt;= to_date('26/oct/2013 15:00:00','dd/mon/yyyy hh24:mi:ss')
  </code></pre>
  
  <p>But the result has 27/10/2013 8:00:00 AM also in end_time column.</p>
  
  <p>Can any one help me finding the mistake?</p>