[solved]date_format sql in query

[eluser]swgj19[/eluser]
I am trying to convert 2012-09-17 to a clean date format September 17th, 2012 by sql in my query. Then I need to include this function in my foreach loop in my view. I need to convert this with sql format and not php.

I am reading that this can be done by sql using DATE_FORMAT.

I just do not know how to accomplish this in my codeigniter query in model and pass to view

Code:

<?php
if (count($posts)){
foreach ($posts as $key => $list){
  echo "<div class='posts'>";
  echo "<h2>".$list['title']."</h2>\n";
  echo "<h5>".$list['pub_date']."</h5>\n";
  echo auto_typography(word_limiter($list['body'], 100));
  echo anchor('blog/post/'.$list['id'],'read more');
  echo '</div>';
}
echo "<br/><br/>";
}