title: Issue with Fetching Date using SYSDATE?
body: <p>I have a table structure having a EMP_DATE column as below</p>
  
  <pre><code> ID       EMP_DATE
  ----    -----------
  5400     14-FEB-2012
  </code></pre>
  
  <p>and i have inserted records into the table as below</p>
  
  <pre><code>INSERT INTO TEST_DATE VALUES(5400,SYSDATE);
  </code></pre>
  
  <p>After inserting records while i am trying to fetch the records of those who has <code>EMP_DATE</code>
  as <code>SYSDATE</code> its giving no rows selected.
  For time being let the <code>SYSDATE</code> be '01-JUL-2012`</p>
  
  <pre><code> SELECT * FROM TEST_DATE WHERE EMP_DATE = SYSDATE;
                  (OR)
   SELECT * FROM TESt_DATE WHERE EMP_DATE = '01-JUL-2012';
  </code></pre>
  
  <p>i was not able figure out any solution .
  Any suggestions would be helpful .</p>