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

31 votes217 views6 answers
Try except
Python
0 vote216 views1 answer
Dictionary lookup python
Python
15 votes216 views3 answers
Not in pandas condition
Python
2 votes211 views1 answer
Django models distinct
Python
1 vote215 views2 answers
List all virtualenv in python
Python
1 vote218 views1 answer
Merged all dictionaries in a list python
Python
0 vote226 views2 answers
Prevent division by zero numpy
Python
11 votes208 views3 answers
How to get the length of a string in python
Python
10 votes221 views3 answers
Execute linux command in python
Python
0 vote226 views1 answer
Django amzon like app
Python Django