Splunk Enterprise

Splunk Time Conversion

OiskyPoisky
Explorer

Morning Team,

Currently looking at trying to convert what i think is 10 digit Unix/Epoc time into a human readable format but struggling to find the right syntax.

"timestamp" field values:

1561012289
1561012304
1561012315
1609193962

 

Any assistance would be appreciated, happy to provide more info if needed!

Labels (1)
0 Karma
1 Solution

to4kawa
Ultra Champion

try strptime with %S

View solution in original post

0 Karma

OiskyPoisky
Explorer

Thanks Kindly! 

Fiddled around a little but got to this eventually:

| eval timestamp=strftime(timestamp, "%Y-%m-%d")

Thanks for pushing me in the right direction 🙂 

0 Karma

to4kawa
Ultra Champion

try strptime with %S

0 Karma
Get Updates on the Splunk Community!

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...

From GPU to Application: Monitoring Cisco AI Infrastructure with Splunk Observability ...

AI workloads are different. They demand specialized infrastructure—powerful GPUs, enterprise-grade networking, ...

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...