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 votes141 views1 answer
Selenium webdriver imports
Python
2 votes145 views1 answer
Selenium find button by text
Python
0 vote135 views1 answer
Create new column with mask pandas
Python
1 vote174 views1 answer
How to filter queryset with foreign key in django
Python Django
1 vote145 views1 answer
Remove single and double quotes from string python
Python
1 vote121 views2 answers
Python Non-UTF-8 code starting with
Python
1 vote136 views1 answer
How to remove arrays in python from a specific place
Python
0 vote149 views1 answer
Quantile-quantile plot python
Python
0 vote141 views1 answer
Pd.concat has nan
Python
4 votes93 views1 answer
Python max float
Python