22 Jul 2024
04:40 PM
- last edited on
23 Jul 2024
07:33 AM
by
MaciejNeumann
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
29 Sep 2025 04:22 PM - edited 29 Sep 2025 04:23 PM
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