topic Re: How to convert date in Splunk Search

How to convert date

hank72 — Sat, 01 Oct 2022 05:55:02 GMT

How to convert Windows lastLogonTimestamp from this format 07:17.45 PM, Fri 09/30/2022 to 09/30/2022 19:17:45

Thank you

Re: How to convert date

gcusello — Sat, 01 Oct 2022 06:13:17 GMT

to convert a date, you have to transform it in epochtime (using strptime) and then again the output format (using strftime) in an eval command, something like this:

| eval lastLogonTimestamp=strftime(strptime(lastLogonTimestamp,"%H:%M.%S %p, %a %m/%d/%Y"),"%m/%d/%Y %H:%M:%S")

for more infos see at

https://docs.splunk.com/Documentation/SCS/current/SearchReference/DateandTimeFunctions#strptime.28.26lt.3Bstr.26gt.3B.2C_.26lt.3Bformat.26gt.3B.29

https://docs.splunk.com/Documentation/SCS/current/SearchReference/DateandTimeFunctions#strftime.28.26.2360.3Btime.26.2362.3B.2C.26lt.3Bformat.26gt.3B.29

Ciao.

Giuseppe

Re: How to convert date

hank72 — Sat, 01 Oct 2022 06:25:24 GMT

Thank you Giuseppe, however my time is still showing up as 07:17:45 and not as 19:17:45

Re: How to convert date

gcusello — Sat, 01 Oct 2022 13:29:24 GMT

Hi @hank72,

sorry, my error:

| eval lastLogonTimestamp=strftime(strptime(lastLogonTimestamp,"%I:%M.%S %p, %a %m/%d/%Y"),"%m/%d/%Y %H:%M:%S")

Ciao.

Giuseppe

Re: How to convert date

hank72 — Sun, 02 Oct 2022 01:50:45 GMT

Thank you! It worked!

Re: How to convert date

gcusello — Sun, 02 Oct 2022 05:40:32 GMT

Hi @hank72,

good for you, see next time!

Ciao and happy splunking

Giuseppe

P.S.: Karma Points are appreciated 😉