title: How to select specific date in Oracle
body: <p>I want to select just 1st and 20th date in Oracle Database.
  Here is my query.</p>
  
  <pre><code>SELECT INVOICE_DATE 
  FROM invoice_debt@stilng1_lngrpt2 
  WHERE INVOICE_DATE = TO_DATE('01', 'DD')
  AND INVOICE_DATE = TO_DATE('20','DD')
  AND INVOICE_DATE &gt; TO_DATE('30-12-2010', 'DD-MM-YYYY')
  AND INVOICE_DATE IS NOT NULL GROUP BY INVOICE_DATE 
  ORDER BY INVOICE_DATE DESC;
  </code></pre>
  
  <p>My query run this :</p>
  
  <ol>
  <li>Select just 1st date </li>
  <li>Select just 20th date</li>
  <li>Select date > 30-12-2010</li>
  </ol>
  
  <p>But nothing records returned.</p>
  
  <p>I try using <code>EXTRACT</code> to get Day of DATE, but i cannot using <code>WHERE</code> clause.</p>
  
  <pre><code>SELECT 
  EXTRACT(DAY FROM TO_DATE(INVOICE_DATE, 'DD-MM-YY')) as DAY_EXTRACT 
  FROM invoice_debt@stilng1_lngrpt2;
  </code></pre>
  
  <p>Please help me thank you.
  :)</p>