Hi guys,
You were right, there was something wrong with my original query:
SELECT cast(tasks_start as date) FROM "tasks" WHERE (Date(tasks_start) in ('2016-08-10');
I was able to get the expected data using the above query...
Cheers
Patrick
SELECT cast(tasks_start as date) FROM "tasks" WHERE (Date(tasks_start) in ('2016-08-10');