On Wednesday, May 24 2006, Christian Smith wrote: > Datetime in SQLite is represented as a 64 bit floating point > value. The units are seconds since the unix epoch. > > What you're seeing is the limited precision (48 bits I believe) > of 64 bit floating point numbers. Not a problem for real world > values, but a problem if high sub-second precision or long > distant dates are needed.
A reasonable explanation, and the insight I was seeking. Thank you. Christian Werner PS: The code and comments in date.c make for a good read.
