Sqlalchemy date beween

qry = DBSession.query(User).filter(User.birthday.between('1985-01-17', '1988-01-17'))
#or
qry = DBSession.query(User).filter(
        and_(User.birthday <= '1988-01-17', User.birthday >= '1985-01-17'))
# or same:
qry = DBSession.query(User).filter(User.birthday <= '1988-01-17').\
        filter(User.birthday >= '1985-01-17')

Source: stackoverflow.com

Similar codes

40 votes110 views6 answers
How to install beautiful soup
Python
-1 vote110 views1 answer
Python one sample t-test
Python
1 vote114 views1 answer
Pyhton turtle delete
Python
1 vote85 views1 answer
From django.conf.urls import patterns
Python
1 vote95 views1 answer
How to add lists to lists in python
Python
1 vote103 views3 answers
Decimal hour to hour minute python
Python
0 vote94 views2 answers
Adding labels to histogram bars in matplotlib
Python
0 vote99 views1 answer
Django table view sort filter
Python
2 votes56 views1 answer
Python maths max value capped at x
Python
1 vote99 views1 answer
Subprocess the system cannot find the file specified
Python