> WHERE STRFTIME('%Y-%m-%d %H:%M', timestamp) = STRFTIME('%Y-%m-%d %H:%M',
'now', 'localtime', '-1 minute');Won't this run strftime on all rows? Unless you have a calculated index on that strftime function, I think you should convert the 'now' to a timestamp… Unless of course your table is 5 rows long :) On Mon, Oct 30, 2017 at 3:21 PM <nitpi...@arcor.de> wrote: > On Monday, 30 October 2017 07:27:38 CET Richard Hipp wrote: > > On 10/30/17, nitpi...@arcor.de <nitpi...@arcor.de> wrote: > > > I was trying with parenthesizing but without luck. > > > (SELECT ... ) - (SELECT ... -1 day ...); > > > > You want: > > > > SELECT (SELECT ...)-(SELECT ... -1 day ...); > > OMG, so easy! > Thank You very much. > > Matth > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
