Getting Data In

Converting into EPOCH time

Rukmani_Splunk
Path Finder

Hi  All,

 I  want  to convert  the following  into  Epoch  time ,but  it  is not  getting  resolved.

 

2020-10-05 23:06:05.946Asia/Singapore  and i  use the below  command 

 

eval  time=strptime("testtime",%Y-%m-%d%s%H:%M:%S.%3N")

0 Karma
1 Solution

renjith_nair
Legend

Try

 |eval time=strptime(test,"%Y-%m-%d %H:%M:%S.%3N%Z")
---
What goes around comes around. If it helps, hit it with Karma 🙂

View solution in original post

renjith_nair
Legend

Try

 |eval time=strptime(test,"%Y-%m-%d %H:%M:%S.%3N%Z")
---
What goes around comes around. If it helps, hit it with Karma 🙂

Rukmani_Splunk
Path Finder

Thanks a lot  it  is working  

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

How to Break a Kubernetes Pod on Purpose and Let the AI Troubleshooting Agent Find ...

Let's say I've just rolled out a Kubernetes Deployment with a typo in the image tag. Nothing explodes. The pod ...

Splunk Add-on for Microsoft Windows 11.0.3: Parse Once, Search Faster

The updated Splunk Add-on for Microsoft Windows helps customers search Windows events faster by reducing ...

What's New in Splunk Enterprise Security 8.8 and Beyond

Threats move at machine speed. Keeping up should not depend on having the biggest budget, the largest team, or ...