MySQL Date and Time Exercises: Query to display the current date in the specified format

MySQL Date Time: Exercise-14 with Solution

Write a query to display the current date in the specified format.

Code:

SELECT date_format(CURDATE(),'%l:%i %p %b %e, %Y');

Sample output:

date_format(CURDATE(),'%l:%i %p %b %e, %Y')
12:00 AM Aug 30, 2017

MySQL Code Editor:

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

Previous:Write a query to display the current date in a spacific format.
Next:Write a query to get the firstname, lastname who joined in the month of June.