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

3 votes319 views1 answer
Find angle mbc in python
Python
0 vote352 views1 answer
How to use self.list.setCurrentRow() in pyqt5
Python
0 vote342 views1 answer
Pandas df.index.values
Python
2 votes337 views3 answers
Python relative path
Python
0 vote345 views1 answer
Numpy array divide each row by its sum
Python
0 vote372 views1 answer
Get name of a file in python
Python
2 votes335 views1 answer
Add role discord .py
Python
0 vote394 views1 answer
Rom pathlib import Path # Build paths inside the project like this: BASE_DIR / 'subdir'. BASE_DIR = Path(__file__).resolve().parent.parent
Python
0 vote334 views1 answer
Create new column with length of old column value python
Python
42 votes384 views6 answers
Pickle dump
Python