Re: [sqlite] SQLite Date problem
P Kishor wrote: > On Sun, Sep 20, 2009 at 4:16 AM, Dan Bishop wrote: > >> Max_wang wrote: >> >>> A few months ago,I used SQLite 3.5.0 execute SQL:"SELECT >>> date(253392451200.0, >>> 'unixepoch');" >>> The result was "-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
Re: [sqlite] SQLite Date problem
On Sun, Sep 20, 2009 at 4:16 AM, Dan Bishop wrote: > Max_wang wrote: >> A few months ago,I used SQLite 3.5.0 execute SQL:"SELECT date(253392451200.0, >> 'unixepoch');" >> The result was "-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
Re: [sqlite] SQLite Date problem
Max_wang wrote: > A few months ago,I used SQLite 3.5.0 execute SQL:"SELECT date(253392451200.0, > 'unixepoch');" > The result was "-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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Date problem
A few months ago,I used SQLite 3.5.0 execute SQL:"SELECT date(253392451200.0, 'unixepoch');" The result was "-09-09". But now I use SQLite 3.6.18 replace it,this SQL execute result is "-1413-03-01". Is this a Bug? -- View this message in context: http://www.nabble.com/SQLite-Date-problem-tp25527521p25527521.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users