Splunk Search

Is there a function to get the week day from any given epoch time?

manus
Communicator

I know how to get the week day from raw events, the week day is stored in the field date_wday.
However, I wonder if there's a function to compute the week day from an epoch time, as I want to get it from a field on a table which doesn't come from a raw event _time.

Tags (4)
1 Solution

manus
Communicator

I once again replied to my own question... Maybe I shouldn't ask so quickly...

|eval date_wday=strftime(epochtime,"%w")

View solution in original post

aweitzman
Motivator

<search> | eval dayofweekshort=strftime(epochtime,"%a") | eval dayofweekfull=strftime(epochtime,"%A") | eval dayofweekasnumber=strftime(epochtime,"%w")

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Commontimeformatvariables

manus
Communicator

I once again replied to my own question... Maybe I shouldn't ask so quickly...

|eval date_wday=strftime(epochtime,"%w")

Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...