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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
