title: Oracle order by year, month
body: <p>I have a query which I want to order by year and then month. I have tryed order by to_date( depdate, 'mm' ) and TO_CHAR(depdate, 'YYYY/MM'). Here is an sqlfiddle to the table i am querying and the query itself <a href="http://sqlfiddle.com/#!4/cda08/2" rel="nofollow">sqlfiddle</a></p>