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

5 votes273 views6 answers
Youtube'
Python
0 vote287 views1 answer
How to write to a netcdf file using xarray
Python
0 vote181 views1 answer
How to tell if member is a bot discord.py
Python
0 vote204 views1 answer
For loop only for first 10 python
Python
1 vote244 views1 answer
Return json with flask
Python Flask
2 votes205 views2 answers
How to store object in file python
Python
1 vote192 views2 answers
Get IP address
Python
0 vote187 views1 answer
Queue using linked list in python
Python
10 votes192 views4 answers
Pandas
Python
0 vote190 views1 answer
Matplotlib FiveThirtyEight horizontal graph
Python