title: How to compare date in Oracle?
body: <p>I'm having issues with what I assumed would be a simple problem, but googling isn't helping a great load. Possibly I'm bad at what I am searching for nether the less.</p>
  
  <pre><code>SELECT ORDER_NUMB, CUSTOMER_NUMB, ORDER_DATE
  FROM ORDERS
  WHERE FORMAT(ORDER_DATE, 'DD-MMM-YYYY') = '07-JUN-2000';
  </code></pre>
  
  <p>It tells me I am using an invalid identifier. I have tried using <code>MON</code> instead of <code>MMM</code>, but that doesn't help either.</p>
  
  <p>Unsure if it makes any difference but I am using Oracle SQL Developer.</p>