SQLAlchemy: how to filter date field?

by

In fact, your query is right except for the typo: your filter is excluding all records: you should change the <= for >= and vice versa:

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')

Also you can use between:

qry = DBSession.query(User).filter(User.birthday.between('1985-01-17', '1988-01-17'))

More Related Contents:

  1. Bulk insert with SQLAlchemy ORM
  2. How can I verify Column data types in the SQLAlchemy ORM?
  3. Getting random row through SQLAlchemy
  4. Select NULL Values in SQLAlchemy
  5. How to execute raw SQL in Flask-SQLAlchemy app
  6. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  7. sqlalchemy: how to join several tables by one query?
  8. SQL Alchemy ORM returning a single column, how to avoid common post processing
  9. SQLAlchemy: cascade delete
  10. Efficiently updating database using SQLAlchemy ORM
  11. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  12. SQLAlchemy ManyToMany secondary table with additional fields
  13. Python, SQLAlchemy pass parameters in connection.execute
  14. Complex foreign key constraint in SQLAlchemy
  15. How do you join two tables on a foreign key field using django ORM?
  16. How to see the raw SQL queries Django is running?
  17. SQLAlchemy: engine, connection and session difference
  18. sqlalchemy: create relations but without foreign key constraint in db?
  19. How to get rows which match a list of 3-tuples conditions with SQLAlchemy
  20. How to execute “left outer join” in SqlAlchemy
  21. flask-sqlalchemy or sqlalchemy
  22. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  23. SQLAlchemy Obtain Primary Key With Autoincrement Before Commit
  24. How to update sqlalchemy orm object by a python dict
  25. Is possible to mapping view with class using mapper in SqlAlchemy?
  26. SQLALchemy dynamic filter_by
  27. VALUES clause in SQLAlchemy
  28. using sqlalchemy to load csv file into a database
  29. SQLAlchemy ordering by count on a many to many relationship
  30. flask sqlalchemy query with keyword as variable

Leave a Comment