A list of invoice no, and order date. Last column shows the order date in weekday name-day of the month-month-year format. All the orders listed here are placed after year 2007:

Invoice no	Order date	DATE_FORMAT(ord_date,'%W %D %M %Y')
INV0001	2008-07-06	Sunday 6th July 2008
INV0002	2008-08-09	Saturday 9th August 2008
INV0003	2008-09-15	Monday 15th September 2008