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

4 votes341 views5 answers
Module 'datetime' has no attribute 'now' django
Python
0 vote365 views1 answer
How to find the medium, first, second and third quartile in a pandas data frame
Python
9 votes339 views3 answers
Print for loop in same line python
Python
2 votes347 views2 answers
Moving average numpy
Python
0 vote320 views1 answer
How to count number from 1 to 10 in python
Python
29 votes441 views4 answers
Basic flask app python
Python Flask
4 votes375 views3 answers
Pip clear cache command
Python
50 votes342 views6 answers
Python uppercase
Python
7 votes359 views2 answers
Select column in pandas dataframe
Python
1 vote339 views1 answer
How to parse dicts in reqparse in flask
Python