Re: [sqlite] Issue 608 in sqlite-manager: select date('2011-04-29', quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17

2011-05-08 Thread Kees Nuyt
On Sun, 08 May 2011 17:27:22 +0200, Thomas Mittelstaedt wrote: >Am Sonntag, den 08.05.2011, 10:08 -0400 schrieb Samuel Adam: >> On Sun, 08 May 2011 09:36:43 -0400, Jean-Christophe Deschamps >> wrote: >> >> > Change that into: >> > >> > select

Re: [sqlite] Issue 608 in sqlite-manager: select date('2011-04-29', quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17

2011-05-08 Thread Samuel Adam
On Sun, 08 May 2011 09:36:43 -0400, Jean-Christophe Deschamps wrote: > Change that into: > > select date('2011-04-29', quote(-3) || ' day'); > > (note the space before day). > Looks like a parsing change. Apparently, yes, between the 3.6 and 3.7 lineages:

Re: [sqlite] Issue 608 in sqlite-manager: select date('2011-04-29', quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17

2011-05-08 Thread Jean-Christophe Deschamps
Change that into: select date('2011-04-29', quote(-3) || ' day'); (note the space before day). Looks like a parsing change. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Issue 608 in sqlite-manager: select date('2011-04-29', quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17

2011-05-08 Thread Richard Hipp
ove 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.

Re: [sqlite] Issue 608 in sqlite-manager: select date('2011-04-29', quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17

2011-05-08 Thread Thomas Mittelstaedt
can see in my previous mail: 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) |