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

10 votes149 views6 answers
How to add a value to a list in python
Python
0 vote94 views1 answer
Python sort list of tuples lexicographically
Python
3 votes128 views2 answers
Module pygame has no member
Python
0 vote97 views1 answer
"api_view" is not defined django
Python
1 vote140 views3 answers
How to access variable of one function in another function in python
Python
0 vote139 views1 answer
Ecrire un code permettant de changer les valeurs de la colonne avec ces deux labels python.
Python
4 votes133 views3 answers
How to make a button in python
Python
1 vote136 views1 answer
Insert data in django models
Python
0 vote140 views3 answers
Groupby fillna
Python
3 votes150 views2 answers
List vs tuple python
Python