Convert time in a field to human readable

[tdebonee]

Hello, I have a field called "startTime"

startTime: 1699148280000

I would like to convert it to human readable. Not having any luck.

Any help would be appreciated.

[tdebonee]

Thank you. That worked.

[ITWhisperer · Accepted solution]

It looks like it might be milliseconds, so divide by 1000 before using strftime() to format it into human readable format.

| eval start_time=strftime(startTime/1000,"%F %T.%3N")