Answered: https://stackoverflow.com/a/46428432/440323
On Tuesday, September 26, 2017 at 7:25:25 AM UTC-4, Terrence Brannon wrote: > > Since there has been no response here, I have posted my question at Stack > Overflow: > > https://stackoverflow.com/questions/46425184/pydal-query-records-newer-than-a-certain-date > > On Monday, September 25, 2017 at 3:40:10 AM UTC-4, Terrence Brannon wrote: >> >> Hello, I have the following query working in pure SQL on SQLite but do >> not know how to convert it to pyDAL: >> >> SELECT * FROM buy WHERE date('now','-2 days') < timestamp; >> >> The buy table schema is: >> >> CREATE TABLE "buy"( >> "id" INTEGER PRIMARY KEY AUTOINCREMENT, >> "order_id" CHAR(512), >> "market" CHAR(512), >> "purchase_price" DOUBLE, >> "selling_price" DOUBLE, >> "amount" DOUBLE >> , "timestamp" TIMESTAMP, "config_file" CHAR(512)); >> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
