How to get the current date in MySQL

In this post we will see how to get the current date in MySQL.

Curdate() returns the current date, so using curdate() we can get the current date in MySQL.

Select Curdate();
+------------+
| curdate()  |
+------------+
| 2023-10-05 |	
+------------+    

curdate() is used to get the current date in MySQL.

By using current_date

current date can be get by using current_date function.

Select Current_date();
+------------+
| current_date()  |
+------------+
| 2023-10-05 |	
+------------+ 

we can also simple use select current_date;

Select Current_date;
+------------+
| current_date  |
+------------+
| 2023-10-05 |	
+------------+