I have a sqlite database where I have a table called result and a column named for_date which stores data in the format of
YYYY-MM-DD HH:MM:SS
where I want to filter data for just particular date. for example
2020-12-12
so it should fetch all the data for that date.
I tried strftime,date functions but they seems to be not working.
can anybody help here?
below query gives data for date greater than date passed which includes all the days after that, which I don't want
select result.id result.subject,result.studentid,result.for_date as date
from result
where for_date >='2022-12-10';
