SQLAlchemy,带日期间隔的查询,按时间\u开始和时间\u结束过滤

sqlalchemy.DateTime 对象,您可以运行一个非常简单的过滤器;sqlalchemy使用python datetime.datetime() 对象

class Element(Base):
    __tablename__ = 'elements'
    id = Column(Integer, primary_key=True)
    name = Column(String(64))
    dt = Column(DateTime)

date_start = datetime(2017, 10, 27, 2, 0)
date_finish = datetime(2017, 10, 27, 4, 0)

all_elements_on_interval = session.query(Element).filter(and_(Element.dt >= date_start, Element.dt <= date_finish)).all()

不要忘记导入datetime和sqlalchemy以及_

from datetime import datetime
from sqlalchemy import and_