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?! -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
