Security

How do you convert extracted fields from a 12 hour format to a 24 hour format?

arunsoni
Explorer

I have two fields that are extracted in Splunk i.e.. start time and end time which is in 12 hours formats. I want to convert them to 24 hours format. Can someone help on this ?

here is the data below,
start time : 11/21/2018 11:04:54 AM, End time : 11/21/2018 11:04:56 AM
start time : 2010-04-01,,11/20/2018 6:59:59 PM, End time :11/20/2018 7:03:20 PM

Tags (2)
0 Karma

Vijeta
Influencer

You can use the below commands to convert time to 24hr format

convert timeformat="%Y/%m/%d %I:%M:%S %p" MkTime(start_time) as new_start_time| convert ctime(new_start_time) as start_time
0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...