How can i calculate datetime Difference between two datetime values.

abhishekgupta61 — Thu, 03 May 2018 09:19:06 GMT

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

Expected Result should be - 70

Re: How can i calculate datetime Difference between two datetime values.

xpac — Thu, 03 May 2018 15:20:26 GMT

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

topic How can i calculate datetime Difference between two datetime values. in Splunk Search

How can i calculate datetime Difference between two datetime values.

Re: How can i calculate datetime Difference between two datetime values.