Splunk Search

How to round down time to nearest 10th minute

sammyshinde14
New Member

Hi,
I want to convert my now() time to round down to nearest 10th minute.

For e.g.
If now returns 10:02 I want it to be converted to 10:00, if its, 10:18 then 10:10.

How can we achieve that?

0 Karma

Sukisen1981
Champion
| eval time=strftime((floor(now()/600))*600,"%Y-%m-%d %H:%M:%S")

Just adding on to @renjith.nair 's cddoe for minor time format issues

Sukisen1981
Champion

hi @sammyshinde14

If the solutions above worked out, please accept the answer , otherwise let us know what is the remaining issue

0 Karma

renjith_nair
Legend

@sammyshinde14 ,

Try

|eval time=(floor(now()/600))*600
---
What goes around comes around. If it helps, hit it with Karma 🙂
Get Updates on the Splunk Community!

Index This | Why did the turkey cross the road?

November 2025 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Feel the Splunk Love: Real Stories from Real Customers

Hello Splunk Community,    What’s the best part of hearing how our customers use Splunk? Easy: the positive ...