SQLite Forum

Calculating Trip Duration in Minutes?
Login
> There are EXACTLY 60 seconds in a minute, EXACTLY 60 minutes in an hour, and EXACTLY 24 hours in a day (EXACTLY 1440 minutes in a day and EXACTLY 86400 seconds in a day). EXACTLY. ALWAYS. EVERYTIME. WITHOUT EXCEPTION.

Sorry, but this was only true in former days where a second was defined as 1/86400th of a day (based on rotation of earth). Nowadays, physically, a second is defined on Cs-133 (see SI unit system) which is approximately, but not exactly, coupled to earth rotation. So while your definition is, of course, correct for every-day use, physically is it wrong.