title: How to compare date in string with sysdate in Oracle?
body: <p>I am new with Oracle and still get used to SQL Server.</p>
  
  <p>I do not understand on why the command below would return '1' when clearly sysdate which is today is 29-Apr-15 that clearly before 30-Apr-15</p>
  
  <p>It should return 0. But I do not understand why it returns 1. </p>
  
  <p>Any ideas? Thanks =)</p>
  
  <pre><code>SELECT CASE WHEN sysdate &gt; to_date('30-Apr-15','DD-MON-YYYY') THEN '1' ELSE '0' END
      FROM DUAL
  </code></pre>