How to get the current date in MySQL?

by

To get current date, use the following syntax:

SELECT CURRENT_DATE();

To get the current date in MySQL, you can use the CURDATE() function. Here’s an example:

SELECT CURDATE();

This will return the current date in the format ‘YYYY-MM-DD’.