Splunk Search

change date format

ChetanArgekar
Explorer

HI,
I am receiving data from Solarwinds Server and it is in following format
November 27, 2019 8:34 AM
I need to convert it in to DD/MM/YYYY HH:MM format.
how to do this

Tags (1)
0 Karma

vnravikumar
Champion

Hi

Try this

| makeresults 
| eval test="November 27, 2019 8:34 PM" 
| eval result=strftime(strptime(test,"%B %d, %Y %I:%M %p"),"%d/%m/%Y %H:%M")
0 Karma

ChetanArgekar
Explorer

Thanks for help.
In worked

0 Karma

vnravikumar
Champion

Please accept the answer

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...