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

From: "Narendra A" <narendraa(at)subexgroup(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: is there a way to get hh:mm:ss given seconds
Date: 2002-07-08 14:28:50
Message-ID: 001f01c2268b$c81ae2b0$19ba10ac@narendraa
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Sir,
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

eagerly waiting for response.

Regards
Narendra

DISCLAIMER: This email is bound by the terms and conditions described at
http://www.subexgroup.com/mail-disclaimer.htm

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kevin Brannen 2002-07-08 15:10:46 Re: bit field changes in 7.2.1
Previous Message Roger Mathis 2002-07-08 13:24:18 Variables in PSQL