MySQL Date and Time Exercises: Get the current date in the following format

MySQL Date Time: Exercise-7 with Solution

Write a query to get the current date in the following format.

Sample date : 2014-09-04
Output : September 4, 2014

Code:

SELECT DATE_FORMAT(CURDATE(),'%M %e, %Y') 
   AS 'Current_date';

Sample Output:

Current_date
August 11, 2017

MySQL Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous:Write a query to calculate the age in year.
Next:Write a query to get the current date in Thursday September 2014 format.