title: Oracle SQL comparing dates
body: <pre><code>SQL&gt; select * from porder ;
  
     OID       BILL ODATE
    ------ ---------- ---------
      10        200 06-OCT-13
       4      39878 05-OCT-13
       5     430000 05-OCT-13
      11        427 06-OCT-13
      12        700 06-OCT-13
      14      11000 06-OCT-13
      15      35608 06-OCT-13
      13      14985 06-OCT-13
       8      33000 06-OCT-13
       9        600 06-OCT-13
      16        200 06-OCT-13
  
     OID       BILL ODATE
  ------ ---------- ---------
       1        200 04-OCT-13
       2      35490 04-OCT-13
       3       1060 04-OCT-13
       6        595 05-OCT-13
       7        799 05-OCT-13
  
  16 rows selected.  
  
   SQL&gt; select * from porder where odate='04-Oct-2013';
  
  no rows selected
  </code></pre>
  
  <p>please someone help...why isn't the query working..??</p>