How do we convert int datatype to "time format" like hh:mm:ss

ex:    123092   ( this 12  + 30 min + 92 sec)

       131137   ( 13 + 11 min + 37 sec)

       111747 ( 11 + 17 min + 47 sec)

 

thanks !

Hi Yori,

Try this

=Left(Fields!ColumnName.Value, 2) + "-" + Mid(Fields!ColumnName.Value, 3, 2) + "-" +  Mid(Fields!ColumnName.Value, 5, 2)

ex:    123092   ( this 12  + 30 min + 92 sec)

92 Sekonds? So it is in real 12 h + 31 min + 32 sec instead?

Hi,

You can use example,  see this below expression.

declare @i int
--set @i = 3621
set @i = 363719 -- more than 100 hours
select replace(str(@i/3600,len(ltrim(@i/3600))+abs(sign(@i/359999)-1)) + ':' + str((@i/60)%60,2) + ':' + str(@i%60,2),' ','0')

Thanks.

Hi,

Please find the below query:

Thanks.

Thank for answer Milan

its really helpful