Splunk Search

How to convert this string to a date?

nicocin
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

javiergn
Super Champion

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

javiergn
Super Champion

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

nicocin
Path Finder

Hmm I get something like this "1463714162.007000"

0 Karma

javiergn
Super Champion

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

nicocin
Path Finder

Ahh ok, working great like this.

Thank you!

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...