Try this:
| stats count
| fields - count
| eval timestamp = "2016-05-20T05:16:02.007+02:00"
| eval timestamp_epoch = strptime(timestamp, "%Y-%m-%dT%H:%M:%S.%3N%z")
Try this:
| stats count
| fields - count
| eval timestamp = "2016-05-20T05:16:02.007+02:00"
| eval timestamp_epoch = strptime(timestamp, "%Y-%m-%dT%H:%M:%S.%3N%z")
Hmm I get something like this "1463714162.007000"
Yes, that's epoch time and that's what Splunk uses internally to represent dates and times.
http://www.epochconverter.com
https://en.wikipedia.org/wiki/Unix_time
What were you planning to do with that timestamp after that?
Now that it's in the right format you can use strftime and plenty or other functions to work with it. For example:
| eval date = strftime(timestamp_epoch, "%Y-%m-%d")
Ahh ok, working great like this.
Thank you!