title: Ordering date (dd-mm-yyyy) in SQL using Google BigQuery
body: <p>I have a query that returns the <em>date</em>,<em>value</em>, and <em>category</em>:</p>
  
  <pre><code>SELECT Date, Value, Category FROM MyTable
  </code></pre>
  
  <p><strong>Outputs:</strong></p>
  
  <pre>
  18-Dec-2011 ||  6 || Toys   
  01-Apr-2012 || -4 || Dog Collars
  31-May-2012 ||  4 || Cat
  17-Dec-2011 ||  3 || Health & Hygiene    
  12-Dec-2011 ||  3 || Travel & Training   
  </pre>
  
  <p>When I add <code>Order By Date ASC</code> it puts the date in ascending order based on the <strong><em>date</em></strong> not the year. </p>
  
  <p>I want it to look like this:</p>
  
  <pre>
  12-Dec-2011 ||  3 || Travel & Training 
  17-Dec-2011 ||  3 || Health & Hygiene
  18-Dec-2011 ||  6 || Toys
  01-Apr-2012 || -4 || Dog
  31-May-2012 ||  4 || Cat
  </pre>
  
  <p><strong>Note:</strong> <code>Date</code> is of type <code>string</code>. I am using <a href="/questions/tagged/google-bigquery" class="post-tag" title="show questions tagged &#39;google-bigquery&#39;" rel="tag"><img src="https://i.stack.imgur.com/2NOCA.png" height="16" width="18" alt="" class="sponsor-tag-img">google-bigquery</a>.</p>
  
  <p>How can I get the year in ascending order first, followed by the month, and then date?</p>