Splunk Search

How can I convert it to splunk time format?

ajayrathore
Loves-to-Learn

Hi,

I have a field in the logs like below

 

 

 

2022-12-07T08:40:14.253180536

 

 

 

How can I convert it to splunk time format?

I need to eventually select this field in the table, so the conversion should work within stats

Labels (1)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @ajayrathore ,

what do you mean with "splunk time format"?

if you mean _time (that's epochtime) you can use the strptime function in the eval command

| eval new_time=strptime(your_time, "%Y-%m-%dT%H:%M:%S.9%N")

if instead you're speaking of the time format when a log is acquired and indexed, you have to put in props.conf for that sourcetype:

TIME_FORMAT = %Y-%m-%dT%H:%M:%S.9%N

Ciao.

Giuseppe

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...