SQLite Forum

Calculating Trip Duration in Minutes?
Login
If the timestamps have been automatically generated via any clock which is synchronized via an internet protocol (NTP, ...), then they are UTC not UT1. The  difference can by up to 900 ms. And there is the very, very remote possibility that a leap second has occurred between two timestamps.