title: proper way to sort sql columns
body: <p>I have a table columns that is something like this:</p>
  
  <pre><code>id     |   date
  1      |   January 1 2014 12:00 AM
  2      |   February 1 2014 12:00 AM
  3      |   March 1 2014 12:00 AM
  4      |   April 1 2014 12:00 AM
  5      |   May 1 2014 12:00 AM
  6      |   June 1 2014 12:00 AM
  7      |   July 15 2014 12:00 AM
  8      |   July 15 2014 1:00 PM
  9      |   July 15 2014 2:00 PM
  10     |   July 15 2014 3:00 PM
  </code></pre>
  
  <p>Since ID 1-6 is already passed, I want them to be sorted from the bottom, and the latest one that is upcoming should be sorted at the top.</p>
  
  <p>Desired output:</p>
  
  <pre><code>id     |   date
  7      |   July 15 2014 12:00 AM
  8      |   July 15 2014 1:00 PM
  9      |   July 15 2014 2:00 PM
  10     |   July 15 2014 3:00 PM
  6      |   June 1 2014 12:00 AM
  5      |   May 1 2014 12:00 AM
  4      |   April 1 2014 12:00 AM
  3      |   March 1 2014 12:00 AM
  2      |   February 1 2014 12:00 AM
  1      |   January 1 2014 12:00 AM
  </code></pre>