A list of invoice no, and order date. Last column shows the order date in weekday name-day of the month-month-year format:

Invoice noOrder dateDATE_FORMAT(ord_date,'%W %D %M %Y')
INV00012008-07-06Sunday 6th July 2008
INV00022008-08-09Saturday 9th August 2008
INV00032008-09-15Monday 15th September 2008
INV00042007-08-22Wednesday 22nd August 2007
INV00052007-06-25Monday 25th June 2007
INV00062007-09-20Thursday 20th September 2007