MySQL Date and Time Exercises: Get the current date in Thursday September 2014 format

MySQL Date Time: Exercise-8 with Solution

Write a query to get the current date in Thursday September 2014 format.

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

Code:

SELECT DATE_FORMAT(NOW(), '%W %M %Y');

Sample Output:

DATE_FORMAT(NOW(), '%W %M %Y')
Friday August 2017

MySQL Code Editor:

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

Previous:Write a query to get the current date in the specific format.
Next:Write a query to extract the year from the current date.