Hi I have two date fields that show up in my dash board panel that lists events after visualisation panels.
"2021-11-02 16:53:38" and "11/02/21 at 16:52:37"
I am trying to find a way to reformat the second date (right) to be like the first.
YYYY-MM-DD hh:mm:ss
Is there an easy way?
This is a search query inside a table listing.
Thank you
hi @owulz,
Use strptime and strftime functions.
| eval seconddatetime=strftime(strptime(seconddatetime, "%d/%m/%y at %H:%M:%S"), "%Y-%d-%m %H:%M:%S")
If this reply helps you, an upvote/like would be appreciated.
hi @owulz,
Use strptime and strftime functions.
| eval seconddatetime=strftime(strptime(seconddatetime, "%d/%m/%y at %H:%M:%S"), "%Y-%d-%m %H:%M:%S")
If this reply helps you, an upvote/like would be appreciated.
Thanks so much @manjunathmeti !
You're welcome! You can accept the answer and give it a thumbs up.