# using USQL how to show the duration in Seconds?

**URL:** <https://community.dynatrace.com/t/using-usql-how-to-show-the-duration-in-seconds/19173>\
**Category:** Real User Monitoring\
**Tags:** usql, user-sessions\
**Created:** [April 28, 2020, 9:52pm UTC](https://community.dynatrace.com/t/using-usql-how-to-show-the-duration-in-seconds/19173 "2020-04-28T21:52:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sureshKumarK](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/sureshkumark/32/11469_2.png) [@sureshKumarK](https://community.dynatrace.com/u/sureshKumarK)\
**Post date:** [April 28, 2020, 9:52pm UTC](https://community.dynatrace.com/t/using-usql-how-to-show-the-duration-in-seconds/19173/1 "2020-04-28T21:52:39Z")

</div>

Hi, please let me know converting duration from ms to seconds is doable using USQL? since the results showing in ms it’s not making sense while plotting the chart with Error count/user action count and duration on same axis. it would be nice if I can convert the duration to seconds.

 ![24809-rtinsec.jpg](https://global.discourse-cdn.com/dynatrace/original/2X/6/6173b5ce41ae347f626faf7f5084c151e93a88e3.jpeg)

y axis shows in millions (as duration is in ms)

 ![24845-bar-chart.jpg](https://global.discourse-cdn.com/dynatrace/original/3X/4/1/414eed28b876efcfbd6cc534bde442ad143c84fa.jpeg)

---

<div class="post-metadata">

**Author:** ![JamesKitson](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jameskitson/32/22460_2.png) [@JamesKitson](https://community.dynatrace.com/u/JamesKitson)\
**Post date:** [April 28, 2020, 10:10pm UTC](https://community.dynatrace.com/t/using-usql-how-to-show-the-duration-in-seconds/19173/2 "2020-04-28T22:10:33Z")

</div>

Idea is to be able to do this using mathematical operations which are available now but don’t seem to be available for aggregate functions yet. Looks like it’s planned to be included but no ETA.

> **[Custom queries, segmentation, and aggregation of session data in RUM Classic](https://docs.dynatrace.com/docs/observe/digital-experience/rum-classic/session-segmentation/custom-queries-segmentation-and-aggregation-of-session-data)**
>
> Learn how you can access and query user session data based on keywords, syntax, functions, and more.

![24817-1588111812718.png](https://global.discourse-cdn.com/dynatrace/original/3X/c/9/c9cf66edc7ac164ec0d2dd0e9391767c6848f83d.png)

---

<div class="post-metadata">

**Author:** ![Erin\_Scot](https://avatars.discourse-cdn.com/v4/letter/e/41988e/32.png) [@Erin\_Scot](https://community.dynatrace.com/u/Erin_Scot)\
**Post date:** [June 1, 2022, 6:52pm UTC](https://community.dynatrace.com/t/using-usql-how-to-show-the-duration-in-seconds/19173/3 "2022-06-01T18:52:29Z")

</div>

Very late to this, but in case someone comes to this via a search, as I did: The math function does work now. I’m not certain when it was updated, but you can use something like “duration/1000/60,” as shown above, and the system will do the math for you and put it in your results.

 ![Erin_Scot_0-1654109523759.png](https://global.discourse-cdn.com/dynatrace/original/2X/9/9a999d21cb05dee871ef23c28ee69c2ce0d29f2c.png)

---

<div class="post-metadata">

**Author:** ![Malaik](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/malaik/32/32673_2.png) [@Malaik](https://community.dynatrace.com/u/Malaik)\
**Post date:** [June 4, 2026, 1:22pm UTC](https://community.dynatrace.com/t/using-usql-how-to-show-the-duration-in-seconds/19173/4 "2026-06-04T13:22:24Z")

</div>

Hello,

What is the progress here,

Im stuck with same idea now?

Regards,