Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Ford
Subject Re: Extract date portion of a datetime field
Date
Msg-id CAH-vkx57EPOVUKPhJknp653tcqd6i0KWguoy=UCyt6xrv3ALfw@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
I've used something like this in the past:

SELECT COUNT(p.index_value)
, p.create_datetime::date
FROM people p
GROUP BY p.create_datetime::date

Simple, but it works.

Scott

On Wed, Apr 18, 2018 at 10: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.

I will very much appreciate your feedback.

Respectfully,
Jorge Maldonado

--

Scott Ford
Director of Development

Bullfrog Power Inc.
366 Adelaide Street West, Suite 701
Toronto, ON  M5V 1R9

t:  416.300.8443
f:  416.360.8385

w. bullfrogpower.com


    

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Extract date portion of a datetime field
Next
From: "David G. Johnston"
Date:
Subject: Re: Extract date portion of a datetime field