Splunk Search

Subtract two timestamps in one event

jscottmiller
New Member

Hopefully this is a simple question, but I haven't found a way to do so using either the convert or eval commands. Basically, I have two timestamps in my events, a start time and an end time. I want to compute a duration (preferably in seconds) by subtracting the two. Is there a simple way to do this?

Tags (1)
0 Karma

JohnB
Explorer

Add something like this:

| eval TotalTime = strptime(end_time, "%Y-%m-%dT%H:%M:%S%z") - strptime(start_time, "%Y-%m-%dT%H:%M:%S%z")

(Assuming your date format is in that type of time stamp).

gkanapathy
Splunk Employee
Splunk Employee

You can use either convert mktime() or the eval strptime() functions to convert both timestamps to epoch time, then just subtract one from the other.

Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...