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

From Karl O. Pinc
Subject Converting seconds past midnight to a time
Date
Msg-id 1134879905l.18569l.7l@mofo
Whole thread Raw
Responses Re: Converting seconds past midnight to a time
Re: Converting seconds past midnight to a time
List pgsql-general
Hi,

What is the best way to convert an integer number of
seconds past midnight into a time?  I can't seem to
figure out a way that does not involve casts to strings,
which seems wasteful.

On a related note is there some reason why
interval + int
does not result in the interval plus int number
of seconds?  That would seem the sane approach.
So sane that there must be some reason why it's
not already done.


Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: is this a bug or I am blind?
Next
From: "Karl O. Pinc"
Date:
Subject: Re: DBlink documentation