filter by time in sqlalchemy

gistfile1.py

#http://stackoverflow.com/questions/7075828/make-sqlalchemy-use-date-in-filter-using-postgresql

from sqlalchemy import Date, cast
from datetime import date

my_date = (session.query(MyObject)
      .filter(cast(MyObject.date_time, Date) == date.today())
      .all())


#or , just like sql

query = session.query(MyObject).filter(MyObject.create_time >= '2012-10-26')

query = (session.query(MyObject)
         .filter(and_(MyObject.create_time >='2012-10-25', MyObject.create_time <= '2012-10-26')))

query = (session.query(MyObject)
        .filter(MyObject.create_time.between('2012-10-25', '2012-10-26')))

使用case的方式， 将丢失索引的好处。

Thanks!

thanks!

Thank you.

it's work by filter(cast(MyObject.date_time, Date) == date.today())
thank youu

Thank you for this, spent a while trying to find what I needed and this was it!