CURDATE() : Today's Date in MySQL

Syntax of CURDATE()
CURDATE()
Example :
SELECT CURDATE(); 
Output is 2021-10-16 , this is in the format YYYY-MM-DD


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
YesterdayTodayTomorrow
2021-10-152021-10-162021-10-17

Last Month , Today and Next Month

SELECT CURDATE()- interval 1 month  as LastMonth, 
CURDATE() as Today, 
CURDATE()+ interval 1 Month as NextMonth
Last MonthTodayNext Month
2021-09-162021-10-162021-11-16

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 DayLast Month Last Day
2021-09-012021-09-30

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()
More on BETWEEN DATE Query

Adding current date and time by default to a record.

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

Read more on how to store default date and time in MySQL table here.

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

Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com






    Post your comments , suggestion , error , requirements etc here





    SQL Video Tutorials










    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2021 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer