Solved: Time formatting from a single field

muralianup · ‎03-18-2016

I have a field where time format in: 20020523135537Z which is 05/23/2002 13:53:37 GMT . How can I convert to human readable form in the results ?

richgalloway · ‎03-18-2016

Here's one way.

... | eval timestr = strftime(strptime(field, "%Y%m%d%H%M%S%Z"), "%m/%d/%Y %H:%M:%S %Z") | ...

---
If this reply helps you, an upvote would be appreciated.

richgalloway · ‎03-18-2016

Here's one way.

... | eval timestr = strftime(strptime(field, "%Y%m%d%H%M%S%Z"), "%m/%d/%Y %H:%M:%S %Z") | ...

---
If this reply helps you, an upvote would be appreciated.

muralianup · ‎03-18-2016

Thank you. Works perfect.

Time formatting from a single field