Two time functions in MySQL, used to make a comparison between two times

Timestampdiff, (if the time period is compared to the number of minutes before the time.) Greater than 1 days, equal to 1; less than 1 days, equals 0)

 
   
  

  
    
   
select TIMESTAMPDIFF(DAY,‘2016-11-16 10:13:42‘,NOW());
 
   
  

DATEDIFF, (calculated by 2016-11-16 only, no extra hours minutes, calculated by day)

 
   
  

  
    
   
select DATEDIFF(NOW(),‘2016-11-16 17:10:52‘);
 
   
  

In SQL Server, DateDiff is more powerful than MySQL, but I'm not useless.

From for notes (Wiz)

Two time functions in MySQL, used to make a comparison between two times