count date difference in hours using php and mysql

How can i find the date difference in hours using php and mysq开发者_如何转开发l both.

Use TIMEDIFF() then take the part before the first colon to get the hours.

For MySQL there are a number of DATE/TIME functions, DATEDIFF(), SUBDATE(), SUBTIME()