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 |
INV0004 | 2007-08-22 | Wednesday 22nd August 2007 |
INV0005 | 2007-06-25 | Monday 25th June 2007 |
INV0006 | 2007-09-20 | Thursday 20th September 2007 |