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
