Re: [sqlite] Select statements using date function such as date('-1 day')

[Keith Christian]

On Fri, Dec 28, 2012 at 12:26 PM, Igor Tandetnik <i...@tandetnik.org> wrote:
> You forgot to tell date() function which date it's supposed to subtract one
> day from. Make it date('now', '-1 day')


Thanks, Igor, that fixes the problem, both of these work!

        select * from general where foodate=date('now', '-1 day') limit 10;

        select * from general where foodate=date('now', '-2 day') limit 10;


I appreciate the quick response.


Keith
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users