title: Oracle BETWEEN DATE RANGE syntax correct
body: <p>Good Day,</p>
  
  <p>I have the following PL-SQL query:</p>
  
  <pre><code>SELECT 
      "FileProcessStatus"."ProcessStatusId"
      , "ProcessStatus"."Name"
      , COUNT("FileProcessStatus"."Id") AS Occurrences
  FROM "FileProcessStatus" INNER JOIN "ProcessStatus" 
  ON "FileProcessStatus"."ProcessStatusId" = "ProcessStatus"."Id"
  GROUP BY "FileProcessStatus"."ProcessStatusId", "ProcessStatus"."Name"
  
  WHERE "FileProcessStatus"."CreatedDate" 
  BETWEEN TO_DATE('01-SEP-12','DD-MON-YY') AND TO_DATE('01-OCT-12','DD-MON-YY');
  </code></pre>
  
  <p>Now when I run the query <em>without</em> the WHERE clause, the query gives me the results I'm looking for, but when I include the WHERE BETWEEN because I'm trying to pull data out of two tables based on a date range, then I get the:</p>
  
  <pre><code>ORA-00933: SQL command not properly ended.
  </code></pre>
  
  <p>I researched the problem and I understand the query's not formatted correctly, but I'm trying to stick to ANSI-SQL since I'm working with PL-SQL.</p>
  
  <p>Suggestions, anyone?</p>
  
  <p>TIA,</p>
  
  <p>coson</p>