Re: BUG #1517: SQL interval syntax is accepted by the parser, - Mailing list pgsql-bugs

Roy Badami <roy@gnomon.org.uk> writes:
>     test=> select interval '1 hour 1 minute';
>      interval
>     ----------
>      01:01:00
>     (1 row)

> Hmm, I don't think I really like having a seconds field in the output,
> given that the column is by definition only storing data to a
> precision of a minute.

Leaving out the seconds would make the display ambiguous.

            regards, tom lane