NOW() : Current Date & Time in MySQL

Syntax of NOW()
Example :
Output is 2016-09-17 16:49:41 , this is in the format YYY-MM-DD HH:MM:SS

Now as a number

Yesterday & Tomorrow date by usign NOW()

SELECT NOW()- interval 1 day  as Yesterday, NOW() as Today, NOW()+ interval 1 day as Tomorrow
2019-10-22 13:34:302019-10-23 13:34:302019-10-24 13:34:30

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
2019-09-23 13:34:302019-10-23 13:34:302019-11-23 13:34:30

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.

Visitors Rating
Your Rating

Post your comments , suggestion , error , requirements etc here .

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