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!

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Combine Multiline Logs into a Single Event with SOCK: a Step-by-Step Guide for ...

Combine multiline logs into a single event with SOCK - a step-by-step guide for newbies Olga Malita The ...