SELECT DATE_FORMAT(DATE, '%m %d %Y') FROM table; /*Example with now*/ SELECT DATE_FORMAT(NOW(), '%m %d %Y');