RE: [sqlite] In the year 4461763

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

Re: [sqlite] In the year 4461763

On Tue, 23 May 2006, Chris Werner wrote: Hello, I am just curious about SQLite's date and time manipulation functions. I am using the sqlite3 command line interface on the above described platform. When I select a datetime for 2^47: sqlite> SELECT datetime(140737488355328, 'unixepoch');