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 timeBetweenInDays[/sql]

Published by Bramus!

Bramus is a frontend web developer from Belgium, working as a Chrome Developer Relations Engineer at Google. From the moment he discovered view-source at the age of 14 (way back in 1997), he fell in love with the web and has been tinkering with it ever since (more …)

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.