title: What date format does Oracle/Toad expect?
body: <p>In the Toad editor, I've got this SQL:</p>
  
  <pre><code>SELECT INTERLOPERABCID,AVAILABLEDATE,
  AVAILABLEQHR,CARPHONEID,
  TRUNC((AVAILABLEQHR-1)/12) "COL",
  MOD(AVAILABLEQHR-1,12) "ROW"
  FROM ABC.INTERLOPERAVAILABILITY
  WHERE INTERLOPERABCID&gt;42
  AND AVAILABLEDATE='09/Apr/2012'
  </code></pre>
  
  <p>...but it returns no rows, even though I see many records in the table whose AVAILABLEDATE value = '4/9/2012'</p>
  
  <p>The date format ('09/Apr/2012'; I also tried '04/Sep/2012') looks odd, but at least I get no compilation/execution error with it. When I tried "4/9/2012" and "04/09/2012" it said "ORA-01853: not a valid month"</p>
  
  <p>How must I enter the date to tell it I want to see dates of April 9th, 2012?</p>