title: Oracle date / order by question
body: <p>I want to select a date from oracle table  formatted like select <code>(to_char(req_date,'MM/YYYY'))</code> but I also want to order the result set on this date format.</p>
  
  <p>I want them to be ordered like dates not strings.</p>
  
  <p>Like this</p>
  
  <pre><code>09/2009
  10/2009
  11/2009
  12/2009
  01/2010
  02/2010
  03/2010
  04/2010
  05/2010
  06/2010
  07/2010
  08/2010
  09/2010
  10/2010
  11/2010
  12/2010
  </code></pre>
  
  <p>Not like</p>
  
  <pre><code>01/2010
  02/2010
  03/2010
  04/2010
  05/2010
  06/2010
  07/2010
  08/2010
  09/2009
  09/2010
  10/2009
  10/2010
  11/2009
  11/2010
  12/2009
  12/2010
  </code></pre>
  
  <p>Any way to do this in sql?</p>
  
  <p>Full SQL is:</p>
  
  <pre><code>SELECT (to_char(req_date,'MM/YYYY')) as monthYear, count(req_id) as count
  FROM   REQUISITION_CURRENT t
  GROUP BY to_char(req_date,'MM/YYYY')
  </code></pre>
  
  <p>Thanks</p>