title: Oracle DateTime in Where Clause?
body: <p>I have sql something like this:</p>
  
  <pre><code>SELECT EMP_NAME, DEPT
  FROM EMPLOYEE
  WHERE TIME_CREATED &gt;= TO_DATE('26/JAN/2011','dd/mon/yyyy')
  </code></pre>
  
  <p>-> This returns 10 rows and TIME_CREATED = '26-JAN-2011'</p>
  
  <p>Now when i do this i don't get any rows back,</p>
  
  <pre><code>SELECT EMP_NAME, DEPT
      FROM EMPLOYEE
      WHERE TIME_CREATED = TO_DATE('26/JAN/2011','dd/mon/yyyy')
  </code></pre>
  
  <p>-> Took the greater than out</p>
  
  <p>Any reason why?</p>