CURDATE() function to get present date from MySQL

SELECT CURDATE();

Output is 2025-11-29 , 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.

Yesterday & Tomorrow date by usign CURDATE()

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

Yesterday	Today	Tomorrow
2025-11-28	2025-11-29	2025-11-30

Last Month , Today and Next Month

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

Last Month	Today	Next Month
2025-10-29	2025-11-29	2025-12-29

First Day of Previous Month

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

Last Day of Previous Month

SELECT LAST_DAY(CURDATE() - INTERVAL 1 MONTH)

Last Month First Day	Last Month Last Day
2025-10-01	2025-10-31

Present Month Records

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()

Adding current date and time by default to a record.

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

Examples of CURDATE() to get different range of records.

SQL Date References Group By in Date field NOW() : Current Date with Time
SQL file of CURDATE() queries

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here

CURDATE() : Today's Date in MySQL