Specify Duration Time Literals When Parsing JSON with DQL

strudeau — Thu, 18 Dec 2025 14:09:38 GMT

Hello, I am attempting to parse the following json:

{"ResultCode": "Ok", "DurationMs": "450.1132", "PerformanceBucket": "250ms-500ms"}

I use the following DQL in my notebook:

fetch logs | parse content, "JSON{STRING:ResultCode, STRING:PerformanceBucket, DURATION:DurationMs}:parsedContent"

How can I specify that the Duration is in milliseconds instead of nanoseconds (which is the default)? It looks like the DURATION datatype doesn't allow to pass a duration time literals argument...

Thanks

DQL data types - Dynatrace Docs

Re: How to specify a duration time literals when parsing JSON using DQL?

ChadTurner — Mon, 29 Sep 2025 15:23:29 GMT

can you add in mathematical operators to take your nano and multiply it by 1,000,000?

nanoseconds = (5 ms × 1,000,000) = 5,000,000 ns

topic Specify Duration Time Literals When Parsing JSON with DQL in DQL

Specify Duration Time Literals When Parsing JSON with DQL

Re: How to specify a duration time literals when parsing JSON using DQL?