Found these SQL snippets in a text file I was destined to lose. Hereby, for me to remember:
[sql]# Difference between 2 timestamps (intial):
TIMEDIFF(FROM_UNIXTIME(t.end_timestamp), FROM_UNIXTIME(t.start_timestamp)) AS timeBetweenInHours
# Difference between 2 timestamps (better):
SEC_TO_TIME(t.end_timestamp – t.start_timestamp) AS timeBetweenInHoursBetter
# Difference between 2 timestamps in days:
ROUND((SEC_TO_TIME(t.end_timestamp – t.start_timestamp) + 0) / 240000, 2) AS timeBetweenInDays[/sql]