Re: is there a way to get hh:mm:ss given seconds

On Mon, 8 Jul 2002, Narendra A wrote:

> Is there a way in sql such that if I give seconds it should me return me
> hours:mins:seconds
>
> Eg. Seconds     hh:mm:ss
> 422              1:01:02

foo=# select '422 seconds'::interval;interval
----------00:07:02
(1 row)
-- 
Tod McQuillin