Splunk Search

time format change

vijaysri
Builder

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")
Labels (4)
0 Karma
1 Solution

gcusello
Legend

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

View solution in original post

gcusello
Legend

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

View solution in original post