Convert mysql datetime into some other format!!

Simply change your sql statement to :


SELECT DATE_FORMAT(thedate, '%M %e, %Y, %l:%i%p') as newdate FROM your_table;