CURDATE() function to get present date from MySQL

SELECT CURDATE();

Output is 2023-09-27 , 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
2023-09-26	2023-09-27	2023-09-28

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

Last Month	Today	Next Month
2023-08-27	2023-09-27	2023-10-27

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
2023-08-01	2023-08-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.