date search for day month year in a timestamp or datetime field

// for datetime field like 2001-12-03
select * from user where month(date_of_birth) = 2  

 // for datetime field like 978363171

select * from user WHERE MONTH(FROM_UNIXTIME(date_of_birth)) = MONTH(CURDATE()) AND DAY(FROM_UNIXTIME(date_of_birth)) = DAY(CURDATE()) AND date_of_birth !=0