Get yesterday date in SQL

Question

i am try to request date only yesterday but without success...

My query request.

SELECT registeredDaySell FROM new_sell WHERE DATE_SUB(CURDATE(), INTERVAL 1 DAY)

My date is organized this way.

16 September, 2017

Thanks for helping me out.

user_10851162 · Answer

subdate(now(),1) will return yesterdays timestamp The below code will select all rows with yesterday's timestamp from employee_login page

Select * FROM `employee_login` WHERE `dattime` <= subdate(now(),1) AND `dattime` > subdate(now(),2)

The below code will display yesterday's timestamp

Select subdate(now(),1) ,subdate(now(),2))

This will give