CODE EXAMPLE FOR SQL

sql datetime format

SELECT DATE_FORMAT(DATE, '%m %d %Y') FROM table;

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