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)

kamal singh bisht

View solution in original post

kml_uvce
Builder

use this

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

kamal singh bisht

pr_blr
Explorer

Thanks its working...

0 Karma
Get Updates on the Splunk Community!

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...