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 vote123 views1 answer
Trim strings python
Python
2 votes150 views1 answer
Run flask application in development mode stack overflow
Python Flask
1 vote151 views1 answer
Pyqt5 qlineedit on change
Python
2 votes118 views1 answer
When opening a file in python what does w mean
Python
1 vote93 views1 answer
Find substring in string python
Python
0 vote126 views1 answer
Write a variable and assin a string to it
Python
0 vote132 views2 answers
Python faculty of 0 is 1 faculty of 1 is 1
Python
0 vote117 views1 answer
How to convert each string to a category or int in python dataframe
Python
1 vote122 views2 answers
Unpack list python
Python
-1 vote152 views2 answers
How do you count most frequent item in a list in python
Python