Michael Hanna <zen@hwcn.org> writes:
> I have a table:
>
> michael=# \d healthnotes
> Table "public.healthnotes"
> Column | Type | Modifiers
> --------+--------------------------
> +-------------------------------------------------------------
> posted | timestamp with time zone | not null default
> ('now'::text)::timestamp(6) with time zone
>
> notes | text |
> Indexes: healthnotes_pkey primary key btree (posted)
>
> Often there are multiple entries per day. I want to display the day once,
> with all the entries on that day.
Try casting the timestamp to date,
select * from healthnotes where cast(posted as date) = 'your date here';
Regards,
Manuel.