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 vote281 views1 answer
Notice there is a bug when using astimezone() on utc time. This gives an incorrect result:
Python
0 vote275 views1 answer
Convert pascal annotation to yolo
Python
0 vote287 views1 answer
Compare input with list python
Python
14 votes276 views5 answers
Calculate days between two dates python
Python
0 vote234 views1 answer
Nunique sort
Python
1 vote254 views1 answer
Selenium close current driver but don't quit
Python
3 votes264 views1 answer
N random numbers python
Python
0 vote272 views1 answer
Bs4 table examples python
Python
3 votes274 views4 answers
Django setup in windows
Python
0 vote272 views1 answer
Python cv2 blob detection seg fault
Python