Converting timestamp to date?

MichaelCohen821 — Fri, 09 May 2014 21:03:19 GMT

Hello Splunk Community

I am trying to convert a timestamp, StartTime (current format: 2014-05-09T19:11:52.5165976Z) in my log file data to a simple DD-MON-YY formatting. I have found a number of solutions in these forums, but I cannot seem to get it to work despite numerous attempts.

My original search is: sourcetype="logfile" Status="*" | chart dc(UserId) by StartTime | SORT dc(UserId) desc

I have tried implementing the following code: strptime(StartTime, "%d-%b-%Y") but this makes the Search fail. I’ve also tried using the eval command, but still no results are returned.

Any help would be greatly appreciated.

Thank you,

Mike

Re: Converting timestamp to date?

linu1988 — Fri, 09 May 2014 21:15:40 GMT

Hi Mike,
The timeformat looks to be simple which splunk should have read it automatically which will mean Starttime=_time(default eventtime)

if not you need a convertion before make it to your usable format. So it would go like this

|eval StartTime=strptime(StartTime, "%Y-%m-%dT%H:%M:%S")|eval StartTime=strftime(StartTime,"%d-%b-%Y")

OR
|eval StartTime=strptime(StartTime, "%Y-%m-%dT%H:%M:%S")|convert timeformat="%d-%b-%Y" ctime(StartTime)

Thanks

topic Converting timestamp to date? in Getting Data In

Converting timestamp to date?

Re: Converting timestamp to date?