How to Get Current Date in MySQL?

Problem : 

We would like to get current date in MySQL database. So we need to execute query to solve this. 

Solution :

Write bellow query to get yestarday date - 

SELECT CURDATE() AS `date`;

Output :

date

6/22/2023