i am not getting decimal value for the milliseconds time which is being converted into seconds.
Solved! Go to Solution.
I fear what you're encountering is a limitation of the USQL.
Because the value is returned as an integer value and is stored as ms (integers) in the database, when you perform a division, you're performing an integer calculation which will always round by default.
Don't think there is a workaround for this. Might need to make an RFE (request for enhancement) to see if Dynatrace should add some transformation function to the USQL to change the value from integer to float or double, so then it can be divided properly and have decimals displayed.
Thanks Darko, have raised below one.
USQL duration/1000 doesnt give decimal value for seconds - Dynatrace Community