Splunk Search

time format change

VijaySrrie
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
SplunkTrust
SplunkTrust

Hi @VijaySrrie,

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
SplunkTrust
SplunkTrust

Hi @VijaySrrie,

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

Get Updates on the Splunk Community!

AppDynamics Summer Webinars

This summer, our mighty AppDynamics team is cooking up some delicious content on YouTube Live to satiate your ...

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...