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 vote210 views1 answer
Using django model translation with django rest
Python Django
0 vote188 views1 answer
Global variable not accessible withing thread
Python
0 vote191 views4 answers
How to show variable in Jupyter
Python
1 vote163 views1 answer
Python dynamic object
Python
0 vote200 views1 answer
Add multiple columns to dataframe if not exist pandas
Python
0 vote182 views1 answer
How to define number in python
Python
12 votes163 views2 answers
How to delete all pips
Python
0 vote162 views1 answer
Import ndimage
Python
1 vote157 views1 answer
Pip fuzzywuzzy
Python
2 votes184 views1 answer
How to install dask in python
Python