6 Replies Latest reply: Jan 28, 2015 9:39 AM by Marco Wedel

# int to hh:mm:ss

Hi,

I am converting seconds into hh:mm:ss like

= Interval(Interval#(SUM (Value),'ss'),'hh:mm:ss')

Conversion is working fine but if value is big number it is coming in -ve.
Why it is coming -ve value? Please help/suggest some better solution.

Test:

Load * inline [
id,Value
1,1000,
2,25500000,
3,4556800000,
4,6767676767,
5,6767676767,

];

• ###### Re: int to hh:mm:ss

Are you really sure that you had values in seconds with these sizes?

6767676767 / 3600 / 24 / 365 = 214 years

- Marcus

• ###### Re: int to hh:mm:ss

Hi

can you attach a sample for you req?

-Amay

• ###### Re: int to hh:mm:ss

Hi,

To convert seconds into interval ('hh:mm:ss') use below expression:

interval(div(sum(Value),3600)&':'&(div(sum(Value),60)-div(sum(Value),3600)*60)&':'&mod(sum(Value),60),'hh:mm:ss')

Hope this helps.

Regards,

Andrei Kaliahin

• ###### Re: int to hh:mm:ss

Hi Andrei,

The expression worked as expected . Thank you.

Regards,

Ashish

• ###### Re: int to hh:mm:ss

Hi,

Try like this

Test:

Floor(Value/ 3600) & ':' & Floor(Mod(Value, 3600)/60) & ':' &  Mod(Value, 60) AS HHMMSS

inline [
id,Value
1,1000,
2,25500000,
3,4556800000,
4,6767676767,
5,6767676767

];

Hope this helps you.

Regards,

Jagan.

• ###### Re: int to hh:mm:ss

seems to be a limitation of the Interval#() function rather than the Interval() function:

```= Interval(SUM (Value)/86400,'hh:mm:ss')
```

is working for me.

regards

Marco