SQLite Forum

Global 'local time' setting?
Login
No.  

All datetime values are UT1 Zulu time and are assumed to be in UT1 Zulu time and will be converted to UT1 Zulu time if a timezone offset is specified when they are loaded/read and will be returned sans offset (naive).  The 'localtime' and 'utc' will apply the appropriate offset (well, what the local computer conceives is the correct offset) to convert between naively expressed (offsetless) 'utc' and 'localtime' respectively.

Note I specify UT1 because the time is UT1 time, not UTC.  UTC technically permits there to be a variable number of seconds in a minute but the datetime functions require that there be exactly 60 seconds in a minute so it is really UT1 time, not UTC.

See <https://mperdikeas.github.io/utc-vs-ut1-time.html> for an interesting explanation.