BigHugger
sk Skill · maxrave-dev

stored-timestamp-is-a-local-wall-clock

A timestamp column written through an ORM type converter can hold the local wall clock encoded as if it were UTC — an exact round trip that is only correct through the converter, and the converter is chosen by the field's TARGET TYPE, so declaring a projection field as a raw number silently opts out and applies the offset a second time. Covers why every total still adds up, why the error is exactly zero on some…

installs 8w
0
30-day movement
starts with the next reading
Related entries
1
Connections
0
sqlkotlinbash
Host repository
maxrave-dev/kotlin-footguns
Host stars
479