"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