Re: query question

Michael Hanna <zen(at)hwcn(dot)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.