title: SQL Sort three columns together - day, month, year
body: <p>Is there a way to write an SQL order by query to sort three columns(day,month,year) together not individually. This seems tricky because 2 12 2016 should come before 1 12 2017 if in ascending order. 
  How do I go about this?</p>