topic How to convert a date time field to epoch time? in Splunk Search

How to convert a date time field to epoch time?

splunker9999 — Tue, 09 Aug 2016 20:50:18 GMT

Hi,

I am looking to format my current time to epoch time (as we need to calculate some math function on time)

Time format for incidentEndTimeStr looks like this: 4/11/16 2:52

And used the eval command and strptime function below to change the format, but it doesn't work. Can you please assist?

eval incidentEndTime = strptime(incidentEndTimeStr, "%m/%d/%Y %I:%M")

eval incidentEndTime = strptime(incidentEndTimeStr, "%m/%d/%Y %H:%M")

Thanks

sundareshr — Tue, 09 Aug 2016 20:57:28 GMT

Try this

strptime(incidentEndTimeStr, "%-m/%-d/%y %-H:%-M")

Here's a working sample

| makeresults | eval x="4/11/16 2:52" | eval t=strptime(x, "%-m/%-d/%y %-H:%-M") | eval z=strftime(t, "%-m/%-d/%y %-H:%-M") | table x t z

gcusello — Wed, 10 Aug 2016 06:40:50 GMT

The problem is the year that it's composed by only two digits, so you have to use "%y" instead "%Y".
Bye.
Giuseppe

gcusello — Fri, 09 Sep 2016 11:17:43 GMT

if you're satisfied of the answer, please, accept the answer.
Bye.
Giuseppe