Date and Time format for not an epoch format

[srinivas_gowda]

Hello all,

I have been getting the data and time format in the below way. How do I convert it to the given readable format

20210901225446 -> 2021-09-01 22:54:46

20210901224509 -> 2021-09-01 22:45:09

Thank you.

[isoutamo · Accepted solution]

Hi

there is couple of ways to do it. Here is one

| makeresults
| eval time = "20210901225446"
| eval nTime = strftime(strptime(time,"%Y%m%d%H%M%S"), "%F %T")
| table time nTime

r. Ismo