CURDATE() function to get present date from MySQL

SELECT CURDATE();

Output is 2024-04-26 , this is in the format YYYY-MM-DD

Syntax of CURDATE()

CURDATE()

CURDATE() to get todays, yesterday and tomorrow date with first day last of previous , next months

NOW() & CURDATE()

By using CURDATE() we get the date part only, where as by using NOW() we will get both date and time.

SELECT CURDATE()- interval 1 day  as Yesterday, 
CURDATE() as Today, 
CURDATE()+ interval 1 day as Tomorrow

Yesterday	Today	Tomorrow
2024-04-25	2024-04-26	2024-04-27

SELECT CURDATE()- interval 1 month  as LastMonth, 
CURDATE() as Today, 
CURDATE()+ interval 1 Month as NextMonth

Last Month	Today	Next Month
2024-03-26	2024-04-26	2024-05-26

SELECT DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH,'%Y-%m-01')

SELECT LAST_DAY(CURDATE() - INTERVAL 1 MONTH)

Last Month First Day	Last Month Last Day
2024-03-01	2024-03-31

Starting from 1st day of the current month till now.

SELECT * FROM `dt_table` WHERE  
date BETWEEN DATE_FORMAT(CURDATE() ,'%Y-%m-01') AND CURDATE()

While storing a record MySQL can automatically insert date and time in a column.