Postgres Pro
Downloads
Home   >   mailing lists

Re: Extract date portion of a datetime field - Mailing list pgsql-novice

From David G. Johnston
Subject Re: Extract date portion of a datetime field
Date
Msg-id CAKFQuwZZyv5y7rFh3w1NJDVA5VU62OAt0o6jf_wfqwNnm32LkQ@mail.gmail.com
Whole thread Raw
In response to Extract date portion of a datetime field  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-novice
Tree view
On Wed, Apr 18, 2018 at 7:01 AM, JORGE MALDONADO <jorgemal1960@gmail.com> wrote:
Hello,

I have a table with a datetime field which saves (of course) date and time information. I need to design a query to count the number of records of each date without taking into account the time portion. I have seen that I can use functions like EXTRACT but I do not find how to extract the whole date only.

​select ('2018-04-18T12:24:36'::timestamptz)::date
select to_char(('2018-04-18T12:24:36'::timestamptz), 'YYYY-MM-DD')

David J.​

pgsql-novice by date:

Previous
From: Scott Ford
Date:
Subject: Re: Extract date portion of a datetime field
Next
From: Stephen Froehlich
Date:
Subject: RE: Extract date portion of a datetime field