Postgres Pro
Downloads
Home   >   mailing lists

Re: is there a way to get hh:mm:ss given seconds - Mailing list pgsql-sql

From Tod McQuillin
Subject Re: is there a way to get hh:mm:ss given seconds
Date
Msg-id 20020709234014.Y68009-100000@glass.pun-pun.prv
Whole thread Raw
In response to is there a way to get hh:mm:ss given seconds  ("Narendra A" <narendraa@subexgroup.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: David Stanaway
Date:
Subject: Re: is there a way to get hh:mm:ss given seconds
Next
From: Josh Berkus
Date:
Subject: Re: PLPGSQL language documentation