Home > mailing lists

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

From	Patrick B
Subject	Get date timestamp(3) without time zone column - PGSQL 9.5
Date	September 5, 2016 02:58:36
Msg-id	CAJNY3ivqPUgSCL6ERBV_M_auGuEvnS0E_QP7wBcvF1ZbSe5f=A@mail.gmail.com Whole thread Raw
Responses	Re: Get date timestamp(3) without time zone column - PGSQL 9.5 Re: Get date timestamp(3) without time zone column - PGSQL 9.5 Re: Get date timestamp(3) without time zone column - PGSQL 9.5
List	pgsql-general

Hi guys,

I got the tasks table that has the tasks_start column:

tasks_start | timestamp(3) without time zone

select tasks_start from tasks LIMIT 1;

tasks_start
-------------------
2016-08-10 00:30:00

I'm trying to cast the date, using this query:

SELECT cast(tasks_start as date) FROM "jobs" WHERE "tasks"."deleted" = 'f' AND "tasks"."recurrence_id" = 1 AND (Date(tasks_start) in ('2016-08-10')

but it doesn't work.. I get 0 rows... what am I doing wrong?

cheers

Patrick

From: Craig Ringer
Date: 04 September 2016, 23:29:03
Subject: Re: BDR: Transactions with global lock

From: Sameer Kumar
Date: 05 September 2016, 03:06:24
Subject: Re: Get date timestamp(3) without time zone column - PGSQL 9.5