I need convert seconds in this format hh:mm:ss

[walterweberg]

I have a measure as Integer (it is seconds) and i would like convert this second in the format hh:mm:ss.

 

I tried with TimeSerial(0,0,[Measures].[Tiempo De Permanencia]) but this doesn't work. If i try with TimeSerial(0,0,70) the result is 00:01:10. it is OK but the Measure is the problem. (i think)

 

The [Measures].[Tiempo De Permanencia] was defined as datetype integer.

 

The definition of TimeSerial is:

<DateTime> TimeSerial(<Integer>, <Integer>, <Integer>)

 

I need help.

[walterweberg]

 

I have this error:

 

Mondrian Error:Internal error: argument type mismatch: parameters (int, int, int), actual (java.lang.Integer, java.lang.Integer, java.lang.Double)

 

I don´t know why, because i did the cast:

 

TimeSerial(0,0,Cast([Measures].[Tiempo De Permanencia] as INTEGER))

[hozawa]

Integer is not the same as int. "int" is a primitive while "Integer" is an object. Should post your question to a Java forum in somewhere like stackoverflow.