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
Last Month , Today and Next Month
SELECT NOW()- interval 1 month as LastMonth, NOW() as Today, NOW()+ interval 1 Month as NextMonth
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()