SELECT date_trunc('day', tasks_start at TIME ZONE 'EST')
Note: I have not tried this statement
Is this something you are going to use often? If that is the case then consider to re-model your query. The moment you use an expression on a column it would not use a normal BTree index.
but it doesn't work.. I get 0 rows... what am I doing wrong?
cheers
Patrick
--
--
Best Regards
Sameer Kumar | DB Solution Architect
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533