P Kishor wrote: > On Sun, Sep 20, 2009 at 4:16 AM, Dan Bishop <danbisho...@gmail.com> wrote: > >> Max_wang wrote: >> >>> A few months ago,I used SQLite 3.5.0 execute SQL:"SELECT >>> date(253392451200.0, >>> 'unixepoch');" >>> The result was "9999-09-09". >>> >>> But now I use SQLite 3.6.18 replace it,this SQL execute result is >>> "-1413-03-01". >>> >>> Is this a Bug? >>> >>> >> Apparently so. And the problem first occurs in 5352. >> >> sqlite> SELECT date(106751991167.30063, 'unixepoch'); >> 5352-11-01 >> >> sqlite> SELECT date(106751991167.30064, 'unixepoch'); >> -1413-03-01 > How on earth did you discover that?! The Bisection Method.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
