On 12/28/2012 2:14 PM, Keith Christian wrote:
Is it possible to use the 'date' function to select a date using the date function as below?select * from general where foobar_date=date('-1 day');
You forgot to tell date() function which date it's supposed to subtract one day from. Make it date('now', '-1 day')
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users