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 vote206 views1 answer
Read ms word with python
Python
0 vote188 views2 answers
Decimal to ascii python
Python
0 vote267 views1 answer
Date format django template filter
Python
0 vote207 views1 answer
How to capitalize words in python
Python
0 vote206 views1 answer
Tableau prep encoding to a set of fields in a flow
Python
0 vote249 views1 answer
How to iterate through ordereddict in python
Python
0 vote231 views1 answer
Pandas sort values reset index
Python
1 vote434 views1 answer
Check if the user is logged in django decorator
Python Django
3 votes194 views1 answer
Python for data analysis
Python
2 votes211 views2 answers
Save a Dictionary to File in Python Using the dump Function of the pickle Module
Python