time format change

[vijaysri]

Hi,

I have a field (Lastsynctime) which outputs time in below format

2021-10-02 09:06:18.173

I want to change the time format like 

"%d/%m/%Y %H:%M:%S"

I tried with strf command, which is not working

| eval SyncTime=strftime(Lastsynctime,"%d/%m/%Y %H:%M:%S")

[gcusello · Accepted solution]

Hi @vijaysri,

the strftime option works with epochtime dates, so you have to convert your date from your format to epochtime and then from epochtime in your format, something like this:

| eval SyncTime=strftime(strptime(Lastsynctime,"%Y-%m-%d %H:$M:$S.$3N"),"%d/%m/%Y %H:%M:%S")

Ciao.

Giuseppe