If you want to display the current date and time, use:
SELECT NOW();
If you want to display the current date only, use:
SELECT CURRENT_DATE();
To display the current date and time in MySQL, you can use the NOW() function. Here’s the query:
SELECT NOW();
This will return the current date and time in the format ‘YYYY-MM-DD HH:MM:SS’.