convert selected datetime to date in sqlalchemy

by

That would be by using the cast() expression:

from sqlalchemy import cast, Date

distinct_dates = session.query(cast(Test_Table.test_time, Date)).distinct().all()

or the shortcut method:

distinct_dates = session.query(Test_Table.test_time.cast(Date)).distinct().all()

and if using SQLite, give this a shot:

distinct_dates = session.query(func.DATE(Test_Table.test_time)).distinct().all()

More Related Contents:

  1. How to convert SQLAlchemy row object to a Python dict?
  2. jsonify a SQLAlchemy result set in Flask [duplicate]
  3. Using OR in SQLAlchemy
  4. SQLAlchemy ORM conversion to pandas DataFrame
  5. SQLAlchemy: unexpected results when using `and` and `or`
  6. sqlalchemy: how to join several tables by one query?
  7. How to create an SQL View with SQLAlchemy?
  8. How to update SQLAlchemy row entry?
  9. Serve image stored in SQLAlchemy LargeBinary column
  10. SQLAlchemy: cascade delete
  11. When do I need to use sqlalchemy back_populates?
  12. SQLAlchemy ManyToMany secondary table with additional fields
  13. Can SQLAlchemy be used with Google Cloud SQL?
  14. Updates to JSON field don’t persist to DB
  15. ImportError: No module named MySQLdb
  16. How do I select literal values in an sqlalchemy query?
  17. Get inserted key before commit session
  18. SQLAlchemy multiple foreign keys in one mapped class to the same primary key
  19. SQLAlchemy default DateTime
  20. Setting SQLAlchemy autoincrement start value
  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. SQLAlchemy: get Model from table name. This may imply appending some function to a metaclass constructor as far as I can see
  25. SQLAlchemy – can you add custom methods to the query object?
  26. pandas to_sql all columns as nvarchar
  27. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  28. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  29. Can’t change system default SQLite binary
  30. add column to SQLAlchemy Table

Leave a Comment