On Wed, Apr 18, 2018 at 7:01 AM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)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.