cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

SWQL support for modulo operation

So we can use something like this:

select ToString(((i.LastRunDuration % 3600) / 60)) + 'm ' + ToString((@total % 60)) + 's' AS [Duration]

Rather then this:

,CASE WHEN (i.LastRunDuration / 60) > 0 THEN (ToString((i.LastRunDuration / 60)) + 'm ' + ToString((i.LastRunDuration -(i.LastRunDuration / 60) * 60)) + 's') ELSE (ToString((i.LastRunDuration -(i.LastRunDuration / 60) * 60)) + 's') END AS [Duration]

Tags (1)
0 Kudos
1 Reply
Level 19

Good feature request! Captured.

0 Kudos