SQLite Forum

Incorrect conversion from unixepoch
Login
No, the result is correct.  You have requested the 'utc' operation on which un-applies the local computers concept of the difference between localtime and utc as if the prior speciied timestamp were localtime and you now want it converted to utc.

Assuming that the number 1607787371 represents seconds since the unix epoch UTC, then your request to "unlocalize" it is the cause of your error.  That is, the datetime is *already* utc and there is no need to un-apply the localtime offset again.  

However since you have requested it be done, the computer has merely made it so.