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

Поиск
Список
Период
Сортировка
От Patrick B
Тема Re: Get date timestamp(3) without time zone column - PGSQL 9.5
Дата
Msg-id CAJNY3iuYF1uMC3+PCm5597CrzUQabT4DQubZdNagd0W_dGJ3gQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Get date timestamp(3) without time zone column - PGSQL 9.5  (amulsul <sul_amul@yahoo.co.in>)
Список pgsql-general
Дерево обсуждения
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

В списке pgsql-general по дате отправления: