Splunk Search

86400 in Splunk

phspec
Explorer

What significance does '86400' have in Splunk? For example, why is it used here, '| eval day=floor((now()-_time)/86400)'?

Tags (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

86400 is the number of seconds in 24 hours. In your example it is used to convert the number of seconds since _time into the number of days since _time.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

86400 is the number of seconds in 24 hours. In your example it is used to convert the number of seconds since _time into the number of days since _time.

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

.conf25 Community Recap

Hello Splunkers, And just like that, .conf25 is in the books! What an incredible few days — full of learning, ...

Splunk App Developers | .conf25 Recap & What’s Next

If you stopped by the Builder Bar at .conf25 this year, thank you! The retro tech beer garden vibes were ...

Congratulations to the 2025-2026 SplunkTrust!

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