Showing posts with label datetime. Show all posts
Showing posts with label datetime. Show all posts

Saturday, August 27, 2011

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;