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

0 vote253 views1 answer
Django customize the user model
Python Django
1 vote226 views1 answer
Run 2 loops simultaneously python
Python
16 votes227 views2 answers
Python nonlocal
Python
0 vote224 views1 answer
Separating a relational plot based on a sixth variable | seaborn relational plot
Python
2 votes220 views1 answer
Python install gimp
Python
10 votes237 views2 answers
Replace values in a column by condition python
Python
4 votes252 views6 answers
Counter method in python
Python
0 vote224 views1 answer
Var colors python
Python
-1 vote223 views6 answers
Pandas show column with regular expression
Python
0 vote264 views1 answer
Fix the debug_mode = false django
Python Django