[solved]date_format sql in query

[eluser]swgj19[/eluser]
I have read several articles on this and went to the source
http://dev.mysql.com/doc/refman/5.1/en/d...ate-format

I am trying to accomplish a similar query in ci in my model

mysql> SELECT DATE_FORMAT('2009-10-04 22:23:00', '%W %M %Y');
-> 'Sunday October 2009'

There is a table 'posts' and column 'pub_date'.

Here is what I have so far:

Code:

function format_date(){

    $data = array();
    $this->db->select date_format('pub_date', '%W %M %Y');
    $Q = $this->db->get('posts');
         if ($Q->num_rows() > 0){
           foreach ($Q->result_array() as $row){
             $data[] = $row;
           }
        }
        $Q->free_result();  
        return $data;