title: Order date by day of the week
body: <p>I'm an SQL rookie and trying to figure out how to display dates in a column as the day, and then order by day of the week (i.e. Monday > Tuesday > Wednesday > etc...)</p>
  
  <p>Have the first part down (displaying as the day) but when I order by my 'DAY' column it seems to order alphabetically (i.e. Monday > Friday > Saturday > etc...)</p>
  
  <p>Here is my query:</p>
  
  <pre><code>SELECT last_name, hire_date, TO_CHAR(hire_date, 'DAY') AS Day
  FROM employees
  ORDER BY Day
  </code></pre>
  
  <p>Any input would be much appreciated :)</p>