Splunk Search

How to change time format in my search?

pr_blr
Explorer

I am using search
...|timechart sum(x) by y
but _time is showing as 2014-4-3-T 00:00, but I want the format of _time on the x axis to be 2014-4-3 only. How do I do this?

0 Karma
1 Solution

kml_uvce
Builder

use this

..|timechart sum(x) by y|eval _time=strftime(_time,"%Y"-%m-%d)

View solution in original post

kml_uvce
Builder

use this

..|timechart sum(x) by y|eval _time=strftime(_time,"%Y"-%m-%d)

pr_blr
Explorer

Thanks its working...

0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...