On Sat, May 7, 2011 at 2:03 PM, Thomas Mittelstaedt < tmsta...@t-mittelstaedt.de> wrote:
> Am Samstag, den 07.05.2011, 03:00 +0000 schrieb > sqlite-mana...@googlecode.com: > > Comment #6 on issue 608 by mrinal.k...@gmail.com: select > date('2011-04-29', > > quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17 > > http://code.google.com/p/sqlite-manager/issues/detail?id=608 > > > > This is the equivalent output on my computer; and Firefox 3.6.17 has > sqlite > > 3.7.4 (as you have reported) > > > > user@user-office-laptop:~$ sqlite3 --version > > 3.7.4 > > user@user-office-laptop:~$ sqlite3 > > SQLite version 3.7.4 > > Enter ".help" for instructions > > Enter SQL statements terminated with a ";" > > sqlite> select date('2011-04-29', quote(-3) || 'day'); > > Wait a minute. The previous sql produces 'NULL' output, yes? If so, it's > an sqlite3 problem with that 3.7.4 version, because with my 3.6.16, it's > correct as you can see in my previous mail: > You need a space between the 3 and the 'day'. Your code above is equivalent to: SELECT date('2011-04-29', '-3day'); This is apparently what you mean: SELECT date('2011-04-29', '-3 day'); > > -------- Weitergeleitete Nachricht -------- > > Von: Thomas Mittelstaedt <tmsta...@t-mittelstaedt.de> > > Reply-to: tmsta...@t-mittelstaedt.de > > An: sqlite-mana...@googlecode.com > > Betreff: Re: Issue 608 in sqlite-manager: select date('2011-04-29', > > quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17 > > Datum: Sat, 07 May 2011 04:40:17 +0200 > > > > Am Samstag, den 07.05.2011, 01:41 +0000 schrieb > > sqlite-mana...@googlecode.com: > > > Comment #4 on issue 608 by mrinal.k...@gmail.com: select > date('2011-04-29', > > > quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17 > > > http://code.google.com/p/sqlite-manager/issues/detail?id=608 > > > > > > sqlite manager in firefox uses the sqlite library which is included > with > > > firefox and not the one separately installed on the computer. It is > > > possible that the firefox version 3.6.17 includes a higher version of > > > sqlite library as compared to the earlier firefox versions. > > > According to your report, firefox 3.6.17 includes sqlite 3.7.4 > > > My firefox and Ubuntu have exactly this version of sqlite. > > > > > > > tom@linux1:~$ sqlite3 --version > > 3.6.16 > > tom@linux1:~$ sqlite3 > > SQLite version 3.6.16 > > Enter ".help" for instructions > > Enter SQL statements terminated with a ";" > > sqlite> select date('2011-04-29', quote(-3) || 'day'); > > 2011-04-26 > > sqlite> > > > > > > -- > thomas > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users