Queries of the Lost Ark: timeBetween

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 …