Time Difference

We can find the days, hours, minutes, year difference


SELECT TIMESTAMPDIFF( HOUR , '2011-02-10 11:14:36' , NOW( )) ;

Also this,

SELECT TIMEDIFF( NOW( ) , '2011-02-10 14:06:36' ) ;



There is also a way to add values to date using

SELECT TIMESTAMPADD( HOUR , '2011-02-10 11:14:36' , NOW( )) ;