I have many integer fields (seconds) and wish to convert them to a TIME field HH:MM:SS. I am hoping not to rip them apart and concatenate them back together as demonstrated here:
I am looking for a way to do this in the cube as I will put them in a pivot and do further analysis.
I see there are others are looking for a similar solution as noted in this post:
I was hoping Sisense had an equivalent of something like the below T-SQL command that would do the trick as I do not have more than 24 hours worth of time.
CONVERT(varchar, DATEADD(ms, [SECONDS_COLUMN] * 1000, 0), 114)
Does anybody know any Sisense code that can convert INT to TIME in the cube? If we could do it, would it be moot as there is no TIME field type which would perform arithmetic calculations in a pivot?
Thank you for any guidance :)
Please sign in to leave a comment.