Splunk Search

How to convert time into the Epoch format

samarkumar
Path Finder

Hi
I have a timestamp field with values as below

"2016-08-25T13:30:36.82"
"2016-08-25T13:13:38.737"
"2016-08-25T11:05:32.76"

How i can convert this into the epoch time so that i can use the value to compare with other epoch value.

Your help will be greatly appreaciated.

0 Karma
1 Solution

sundareshr
Legend

Try this

... | eval t=strptime(timestamp. "%Y-%m-%dT%H:%M:%S")

View solution in original post

0 Karma

sundareshr
Legend

Try this

... | eval t=strptime(timestamp. "%Y-%m-%dT%H:%M:%S")
0 Karma

samarkumar
Path Finder

I had a discussion with Sundaresh, and i tried below thing and it works as expected.

..|eval t=strptime(timestamp, "\"%Y-%m-%dT%H:%M:%S")|..

Thank You.

0 Karma
Get Updates on the Splunk Community!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...