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

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: amulsul <sul_amul(at)yahoo(dot)co(dot)in>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Get date timestamp(3) without time zone column - PGSQL 9.5
Date: 2016-09-05 21:13:05
Message-ID: CAJNY3iuYF1uMC3+PCm5597CrzUQabT4DQubZdNagd0W_dGJ3gQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-09-05 21:25:58 Re: postgres question: Views with duplicate field names
Previous Message Adrian Klaver 2016-09-05 20:18:48 Re: postgres question: Views with duplicate field names