Splunk Search
Highlighted

Can you help me convert a field value extracted by a rex command to another date time format?

Explorer

Hello Community,

I have certain field values extracted by using rex command. The timestamp format of the field value is in ISO 8601.
For example -

lgk":"2018-09-24T04:41:54Z"

I need to convert it in the following format

%m-%d-%Y %H:%M:%S %p

I tried using strftime but that doesn't work. Gives blank results. Can somebody please help me with some pointers?

Thanks,
-Ameya

0 Karma
Highlighted

Re: Can you help me convert a field value extracted by a rex command to another date time format?

Super Champion

Try this run anywhere search:

|makeresults|eval t="2018-09-24T04:41:54Z"|eval b=strftime(strptime(t,"%Y-%m-%dT%H:%M:%SZ"),"%m-%d-%Y %H:%M:%S %p")
Highlighted

Re: Can you help me convert a field value extracted by a rex command to another date time format?

Community Manager
Community Manager

Hi @ameyapatil29

Glad you got an answer by @493669 below. I noticed you upvoted his answer, but didn't accept it. If it solved your question, please don't forget to resolve the post by clicking "Accept" directly below his answer.

Thanks!

0 Karma