Splunk Search

Convert epochtime to minutes

nwoolley
Engager

Hi I need to Convert an #epoch time to #minutes any ideas please guys would be really grateful - Thanks

0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @nwoolley,
to convert epochtime you can use the eval command with strftime function ( for more infos see at https://docs.splunk.com/Documentation/Splunk/8.0.0/SearchReference/DateandTimeFunctions ).
In few words:

your_search
| eval my_new_time=strftime(epochtime,"%M")

If you want other time formats see at https://docs.splunk.com/Documentation/SplunkCloud/8.0.0/SearchReference/Commontimeformatvariables

Ciao.
Giuseppe

View solution in original post

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @nwoolley,
to convert epochtime you can use the eval command with strftime function ( for more infos see at https://docs.splunk.com/Documentation/Splunk/8.0.0/SearchReference/DateandTimeFunctions ).
In few words:

your_search
| eval my_new_time=strftime(epochtime,"%M")

If you want other time formats see at https://docs.splunk.com/Documentation/SplunkCloud/8.0.0/SearchReference/Commontimeformatvariables

Ciao.
Giuseppe

0 Karma

nwoolley
Engager

Perfect Grazie !

0 Karma
Get Updates on the Splunk Community!

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

New This Month - Observability Updates Give Extended Visibility and Improve User ...

This month is a collection of special news! From Magic Quadrant updates to AppDynamics integrations to ...

Intro to Splunk Synthetic Monitoring

In our last post, we mentioned that the 3 key pieces of observability – metrics, logs, and traces – provide ...