Splunk Search

How to convert date to epoch?

Shakira1
Explorer

I have this date string example: Mon, 01 May 2023 00:00:00 GMT

how can I convert it to epoch

 

thanks!

Labels (1)
Tags (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

strptime() will convert strings to epoch times

| eval _time=strptime(time,"%a, %d %b %Y %H:%M:%S %Z")

View solution in original post

0 Karma

Shakira1
Explorer

thank you, its working!

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

strptime() will convert strings to epoch times

| eval _time=strptime(time,"%a, %d %b %Y %H:%M:%S %Z")
0 Karma
Get Updates on the Splunk Community!

Troubleshooting the OpenTelemetry Collector

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

Adoption of Infrastructure Monitoring at Splunk

  Splunk's Growth Engineering team showcases one of their first Splunk product adoption-Splunk Infrastructure ...

Modern way of developing distributed application using OTel

Recently, I had the opportunity to work on a complex microservice using Spring boot and Quarkus to develop a ...