Flask-SQLAlchemy选择日期等于今天的数据

１. 模型

class User(db.Model):
	created = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)

2. 选择日期等于今天的数据

User.query.filter(db.cast(User.created, db.DATE) == db.cast(User.created, db.DATE)).all() # mysql正常，　sqlite3中转成ｄａｔｅ格式后，　只剩下年份，没有月份和日期了。

3. sqlite3

from sqlalchemy import extract

User.query.filter(
                extract('year', User.created) == today.year,
                extract('month', User.created) == today.month,
                extract('day', User.created) == today.day).all()

4. 参考

• https://segmentfault.com/q/1010000014045246?utm_source=tag-newest