Re: [GENERAL] Get date timestamp(3) without time zone column - PGSQL 9.5

[Patrick B]

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