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")
OR
eval incidentEndTime = strptime(incidentEndTimeStr, "%m/%d/%Y %H:%M")
Thanks
The problem is the year that it's composed by only two digits, so you have to use "%y" instead "%Y".
Bye.
Giuseppe
if you're satisfied of the answer, please, accept the answer.
Bye.
Giuseppe
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