SqlAlchemy: convert datetime column columns to date
I am trying to convert a column datetime
todate
def filter_between_dates(query, req, db_col):
date_from = req.get_param('date_from')
#date_to = req.get_param('date_to')
query = query.filter(cast(db_col,DATE) == date_from)
return query
The error showed: "name 'DATE' is not defined"
I tried adding import DATE
and got "ImportError:cannot import name 'DATE'"
Perhaps I am doing it wrong from the start. Please guide.
+3
source to share
1 answer
You need to import it.
from sqlalchemy import Date, cast
...
def filter_between_dates(query, req, db_col):
date_from = req.get_param('date_from')
#date_to = req.get_param('date_to')
query = query.filter(cast(db_col,Date) == date_from)
return query
Or you can do it with func:
from sqlalchemy import func
...
query = query.filter(func.date(db_col) == date_from)
+2
source to share