topic Re: Issue with strptime in Splunk Search

Issue with strptime

sethinkbold — Wed, 30 Sep 2020 05:21:53 GMT

I am trying to convert a date / time into 24 hour format using strptime. Here's the example:
OpenedAt = 5/4/2019 9:04:46 PM

I convert it to epoch using the following statement:
eval new_time=strptime(OpenedAt,"%m/%d/%Y %H:%M:%S %p")

When I test it again, it still dosn't show in 24 hour format:
eval new_time2=strftime(new_time,"%m/%d/%Y %T")

05/04/2019 09:04:46

Re: Issue with strptime

vnravikumar — Wed, 06 May 2020 02:48:26 GMT

Check this

| makeresults 
| eval date="5/4/2019 9:04:46 PM",new_date=strftime(strptime(date,"%d/%m/%Y %I:%M:%S %p"),"%d/%m/%Y %H:%M:%S")

Re: Issue with strptime

to4kawa — Wed, 06 May 2020 02:51:12 GMT

| makeresults 
| eval OpenedAt ="5/4/2019 9:04:46 PM" 
| eval new_time=strptime(OpenedAt,"%m/%d/%Y %I:%M:%S %p") 
| eval new_time2=strftime(new_time,"%m/%d/%Y %T")

see reference.
https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Commontimeformatvariables