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

> > I tried all these. This is what I get > > SQL> SELECT "interval"(cast(422 as varchar) || ' seconds'); > > SELECT "interval"(cast(422 as varchar) || ' seconds') > > * > > ERROR at line 1: > > ORA-00906: missing left parenthesis > > > SQL> select '422 second

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

Narendra, > I tried all these. This is what I get > SQL> SELECT "interval"(cast(422 as varchar) || ' seconds'); > SELECT "interval"(cast(422 as varchar) || ' seconds') > * > ERROR at line 1: > ORA-00906: missing left parenthesis > SQL> select '422 seconds'::i

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

Tod McQuillin wrote: > 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:0

Re: [SQL] 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 --

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

On Mon, 2002-07-08 at 09:28, Narendra A wrote: > 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 scratch=# SELECT 422::interval; interval -- 00:07:02 (1 row) scratch=# \q dst

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

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 htt