NOW() : Current Date & Time in MySQL

Output is 2020-09-17 16:49:41 , this is in the format YYY-MM-DD HH:MM:SS

Now as a number ( SELECT NOW() + 0 )

NOW() to get todays, yesterday and tomorrow date with time with sample queries

SELECT NOW()- interval 1 HOUR  as One_hour_back,
 NOW() as Present, 
 NOW()+ interval 1 HOUR as One_hour_After
2024-06-14 14:34:242024-06-14 15:34:242024-06-14 16:34:24

Yesterday & Tomorrow date by using NOW()

SELECT NOW()- interval 1 day  as Yesterday, 
NOW() as Today, 
NOW()+ interval 1 day as Tomorrow
2024-06-13 15:34:242024-06-14 15:34:242024-06-15 15:34:24

Queries using Date and Time

We may require to collect records of last 5 hours or last 24 hours. Here are some queries to find out records based on date and times.
Queries using Date with time

Last Month , Today and Next Month

SELECT NOW()- interval 1 month  as LastMonth, 
NOW() as Today, 
NOW()+ interval 1 Month as NextMonth
Last MonthTodayNext Month
2024-05-14 15:34:242024-06-14 15:34:242024-07-14 15:34:24

Matching only date part ( not time ) with datetime field or Now()

We may store date with time in a table in the above mentioned date and time format. However we can compare the date part only ( without time ) to match the records. Example : We may be storing date and time of login of members in a table but want display all the login members of today or a particular date.
SELECT * from table_name WHERE DATE(date_column)='2019-12-26'
To match current or today's date
SELECT * from table_name WHERE DATE(date_column)=CURDATE()

Read more on 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. Read more on how to store default date and time in MySQL table here.
SQL Date References Group By in Date field DAYOFWEEK() : Get weekdays like Sunday , Monday .. etc
SQL file using NOW() queries
Subscribe to our YouTube Channel here


* indicates required
Subscribe to plus2net

    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-2024 All rights reserved worldwide Privacy Policy Disclaimer