Begin date - 2018-05-02 22:00:23.235371
End Date - 2018-05-02 22:01:33.815546
Expected Result should be - 70
Hey, try this:
| makeresults
| eval begin="2018-05-02 22:00:23.235371"
| eval end="2018-05-02 22:01:33.815546"
| eval begin_epoch=strptime(begin, "%Y-%m-%d %H:%M:%S")
| eval end_epoch=strptime(end, "%Y-%m-%d %H:%M:%S")
| eval diff=end_epoch-begin_epoch
The field diff
will then contain the difference between the two. I left out the milliseconds on purpose, because you said you expected "70" as a result.
Hope that helps - if it does I'd be happy if you would upvote/accept this answer, so others could profit from it. 🙂