Specify Duration Time Literals When Parsing JSON with DQL

[strudeau]

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

[ChadTurner · Accepted solution]

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