Re: Converting seconds past midnight to a time - Mailing list pgsql-general

"Karl O. Pinc" <kop@meme.com> writes:
> What is the best way to convert an integer number of
> seconds past midnight into a time?

Intermediate 'interval' value seems to work:

regression=# select (99.44 * '1 second'::interval)::time;
    time
-------------
 00:01:39.44
(1 row)

> On a related note is there some reason why
> interval + int
> does not result in the interval plus int number
> of seconds?

Again, multiplying the number by '1 sec'::interval would get you there.

            regards, tom lane