My _time format reads 2019-10-13 04:19:21
I try to convert this _time value to the format mm/dd/yyyy day h:m:s AM or PM. Can anyone help me on this?
Thanks,
Like this:
... | fieldformat _time = strftime(_time, "%m/%d/%Y Day %I%M:%S %p")
Like this:
... | fieldformat _time = strftime(_time, "%m/%d/%Y Day %I%M:%S %p")
It's very close to perfect. I now have 10/13/2019 Day 01:48:35 AM. Is it possible to replace "Day" with an actual day Sunday? so the final format would be: 10/13/2019 Sunday 01:48:35 AM
Thank you,
Like this:
... | fieldformat _time = strftime(_time, "%m/%d/%Y %a %I%M:%S %p")
OR
... | fieldformat _time = strftime(_time, "%m/%d/%Y %A %I%M:%S %p")
Perfect! Thank you so much.