carlosmontoya89/SQLAlchemy_cast.py

Forked from danielthiel/SQLAlchemy_cast.py

Created February 3, 2020 21:37

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/carlosmontoya89/6f3b3a4d89a7343c87967eb858d95a38.js"></script>
Save carlosmontoya89/6f3b3a4d89a7343c87967eb858d95a38 to your computer and use it in GitHub Desktop.

Download ZIP

SQLAlchemy: filter by date for an datetime field(does not work with SQLite, with PostgreSQL it works fine)

Raw

SQLAlchemy_cast.py

	from datetime import date
	from sqlalchemy import cast, DATE
	Match.query.filter(cast(Match.date_time_field, DATE)==date.today()).all()

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment