Splunk Search

Date and Time format for not an epoch format

srinivas_gowda
Path Finder

Hello all,

 

I have been getting the data and time format in the below way. How do I convert it to the given readable format

 

20210901225446 -> 2021-09-01 22:54:46

20210901224509 -> 2021-09-01 22:45:09

 

Thank you.

Labels (4)
0 Karma
1 Solution

isoutamo
SplunkTrust
SplunkTrust

Hi

there is couple of ways to do it. Here is one

| makeresults
| eval time = "20210901225446"
| eval nTime = strftime(strptime(time,"%Y%m%d%H%M%S"), "%F %T")
| table time nTime

r. Ismo 

View solution in original post

isoutamo
SplunkTrust
SplunkTrust

Hi

there is couple of ways to do it. Here is one

| makeresults
| eval time = "20210901225446"
| eval nTime = strftime(strptime(time,"%Y%m%d%H%M%S"), "%F %T")
| table time nTime

r. Ismo 

*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!

Review:





Or Learn More in Our Blog >>