sql - Mysql previous date -

i using following have previous date data @ 00.00.00

select * perf timestamp="subdate(curdate(),1)"; 

but not resulting output

where

select * perf timestamp="2014-11-28"; 

resulting proper output

can of please me in trying find out issue.any appreciated.

check subdate() function

try this:

select *  perf date(timestamp) = subdate(curdate(), interval 1 day);