How to convert SWQL "tostring" to number for reporting?

Hi all,

I'm trying to find a way to convert a TOSTRING value to a number so that in my reporting I can display "order by" correctly and not in text.

,case when ack.timestamp is null then 'N/A'

else tostring(minutediff(ah.TimeStamp,ack.timestamp)+0)

end as [Minutes Until Acknowledged]

Thank you!

Find more posts tagged with

int

tostring

SWQL

sql reporting

SWQL Studio

I love when I see my SWQL scripts floating around, haha.

I think you could do something like order by minutediff(ah.TimeStamp,ack.timestamp) to get what you want done.