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
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:
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
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.
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) |
5 matches
Mail list logo