Splunk Search

Help to convert date using strftime

Marco_Develops
Path Finder

Currently I have a field holding a Julian date. I am trying to convert it using strftime but i'm having issues.

 

Date = 2022.091

Current query:

 

 

index = * | eval ConvertedDate = strftime(DATE,"%Y.%j")| table ConvertedDate

 

 

 

Ideally I would like to get an output like 04/03/2022

 

Thank you,

Marco

Labels (2)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

The strftime function converts an epoch timestamp (integer) into a human-readable string.  Use the strptime function to convert a datetime string into epoch form.

 

index = * 
| eval ConvertedDate = strftime(strptime(DATE,"%Y.%j"), "%m/%d/%Y")
| table ConvertedDate

 

 

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

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

The strftime function converts an epoch timestamp (integer) into a human-readable string.  Use the strptime function to convert a datetime string into epoch form.

 

index = * 
| eval ConvertedDate = strftime(strptime(DATE,"%Y.%j"), "%m/%d/%Y")
| table ConvertedDate

 

 

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

Marco_Develops
Path Finder

@richgalloway This worked. Thank you for your time and explanation . 

-Marco

0 Karma
Get Updates on the Splunk Community!

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...

Secure Your Future: Mastering Upgrade Readiness for Splunk 10

Spotlight: The Splunk Health Assistant Add-On  The Splunk Health Assistant Add-On is your ultimate companion ...

Observability Unlocked: Kubernetes & Cloud Monitoring with Splunk IM

Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team on ...