Splunk Enterprise

parsing time

VijaySrrie
Builder

Hi,

How to parse below

2020.08.20 07:38:42 902 +1000

0 Karma
1 Solution

isoutamo
SplunkTrust
SplunkTrust

Hi

Here is example what you can do with it

 

| makeresults
| eval Time1="2020.08.20 07:38:42 902 +1000"
| eval epoch_time = strptime(Time1, "%Y.%m.%d %H:%M:%S %3Q %z")
| eval Time_Human = strftime(epoch_time, "%c")
| eval Time_2 = strftime(epoch_time,"%FT%T.%3Q%:z")

 

More information about time formats:

https://docs.splunk.com/Documentation/Splunk/8.0.5/SearchReference/Commontimeformatvariables

r. Ismo 

View solution in original post

0 Karma

isoutamo
SplunkTrust
SplunkTrust

Hi

Here is example what you can do with it

 

| makeresults
| eval Time1="2020.08.20 07:38:42 902 +1000"
| eval epoch_time = strptime(Time1, "%Y.%m.%d %H:%M:%S %3Q %z")
| eval Time_Human = strftime(epoch_time, "%c")
| eval Time_2 = strftime(epoch_time,"%FT%T.%3Q%:z")

 

More information about time formats:

https://docs.splunk.com/Documentation/Splunk/8.0.5/SearchReference/Commontimeformatvariables

r. Ismo 

0 Karma

harsmarvania57
Ultra Champion

Please provide more information, where you want to parse that timestamp ?

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...