converting seconds in time format

[pucklinger]

Hi,

I got a problem:
I have a column c1 with seconds stored as integer data type.
I want to display time format.
e.g. 61 second should be displayed as 00:01:01.

I tried severel things, but nothing helped.

select time '00:00:00' + interval column1 second from talbe1

doesn't work, because teradata accepts only strings as intervals?!?!?

Has someone a hint for me?

Thanks a lot!

Cheers,
Pucklinger

 

[dnoeth]

If c1 is always less than 9999 you can use
sel 61 as x,
cast(cast (x as interval second(4,0)) as interval hour to second(0));

if it's > 9999:
sel 99999 as x,
cast(
cast (x / 3600 as interval hour(4)) +
cast (x mod 3600 as interval second(4,0))
as interval day(4) to second(0))

Dieter

 

[pucklinger]

Hi Dieter!

thanx for your fast help!
Works perfekt....
Had not the idea to cast as intervall.


Cheers
Pucklinger