convert integer date into formatted text
<p>I have an sql database with a date column like this yyyymmdd (20111109), i usually sort my return queries by the date.</p>

<p>I would like to know how to convert this to the (D jS M) or (Wed 9th Nov).</p>

<p>For the month, date, and ordinal suffix, im using substr along with case. but its the weekday im getting frustrated with. </p>

<p>Is there a simpler method?</p>

<p>Thanks in advance.</p>
