How can i calculate datetime Difference between two datetime values.

[abhishekgupta61]

Begin date - 2018-05-02 22:00:23.235371
End Date - 2018-05-02 22:01:33.815546

Expected Result should be - 70

[xpac]

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. 🙂