Splunk Search

How to convert this string to a date?

Path Finder

I'm trying to convert a string to a date.

The string looks like 2016-05-20T05:16:02.007+02:00

Tags (4)
0 Karma
1 Solution

SplunkTrust
SplunkTrust

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")

View solution in original post

SplunkTrust
SplunkTrust

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")

View solution in original post

Path Finder

Hmm I get something like this "1463714162.007000"

0 Karma

SplunkTrust
SplunkTrust

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")

Path Finder

Ahh ok, working great like this.

Thank you!

0 Karma