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
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

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
: 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

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 Samuel Adam
On Sun, 08 May 2011 09:36:43 -0400, Jean-Christophe Deschamps j...@antichoc.net 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 Kees Nuyt
On Sun, 08 May 2011 17:27:22 +0200, Thomas Mittelstaedt tmsta...@t-mittelstaedt.de 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 j...@antichoc.net wrote: Change that into: select date('2011-04-29',