title: Check if current date is between two dates Oracle SQL
body: <p>I would like to select <code>1</code> if current date falls between 2 dates through Oracle SQL.</p>
  
  <p>I wrote an SQL after reading through other questions.</p>
  
  <p><a href="https://stackoverflow.com/questions/2369222/oracle-date-between-query" title="Oracle date “Between” Query">https://stackoverflow.com/questions/2369222/oracle-date-between-query</a></p>
  
  <p><a href="https://stackoverflow.com/questions/2399753/select-from-table-by-knowing-only-date-without-time-oracle" title="Select from table by knowing only date without time &#40;ORACLE&#41;">https://stackoverflow.com/questions/2399753/select-from-table-by-knowing-only-date-without-time-oracle</a></p>
  
  <p>But it returned only null. <code>sysdate</code> is the current date that is <code>01/05/2014</code> in date format <code>DD/MM/YYYY</code>.</p>
  
  <p>The SQL I wrote is:</p>
  
  <pre><code>select 1 from dual 
  WHERE to_date(sysdate,'DD/MM/YYYY') 
  BETWEEN TO_DATE('28/02/2014', 'DD/MM/YYYY')
  AND TO_DATE('20/06/2014', 'DD/MM/YYYY');
  </code></pre>
  
  <p>and </p>
  
  <pre><code>select 1 from dual 
  WHERE to_date(sysdate,'DD/MM/YYYY') &gt;= TO_DATE('28/02/2014', 'DD/MM/YYYY') 
  AND to_date(sysdate,'DD/MM/YYYY') &lt; TO_DATE('20/06/2014', 'DD/MM/YYYY'); 
  </code></pre>