Postgres Pro
Downloads
Home   >   mailing lists

Re: Get date timestamp(3) without time zone column - PGSQL 9.5 - Mailing list pgsql-general

From Patrick B
Subject Re: Get date timestamp(3) without time zone column - PGSQL 9.5
Date
Msg-id CAJNY3iuYF1uMC3+PCm5597CrzUQabT4DQubZdNagd0W_dGJ3gQ@mail.gmail.com
Whole thread Raw
In response to Re: Get date timestamp(3) without time zone column - PGSQL 9.5  (amulsul <sul_amul@yahoo.co.in>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: postgres question: Views with duplicate field names
Next
From: Tom Lane
Date:
Subject: Re: postgres question: Views with duplicate field names