mysql - how to using dateadd in sqlalchemy with filter? -

the sql expression :

select *    order   status=0     , adddate(created_time, interval 1 day)>now(); 

python code:

from sqlalchemy.sql.expression import func, text datetime import datetime   closed_orders = dbsession.query(order).filter(func.dateadd(order.create_time,         text('interval 1 day'))>datetime.now()).all()  

but it's got wrong. how correctly?

thanks

ref :using dateadd in sqlalchemy

try this:

from sqlalchemy import func import datetime dbsession.query(order)\     .filter(func.adddate(order.create_time,1)>datetime.datetime.now())