Getting Data In

How to define timestamp in props.conf for JSON events?

jwalzerpitt
Influencer

I will be ingesting a JSON file daily that has a K/V field for the date as follows:

 

"Date":  "2023-01-04"

 

I just want to verify the time format in the props.conf file should be set as follows:

 

TIME_FORMAT=%y-%m-%d

 

 Thx

Labels (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

You're close.  The correct time format is

TIME_FORMAT=%Y-%m-%d

Use upper-case 'Y' for 4-digit years and lower-case 'y' for 2-digit years.

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

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

You're close.  The correct time format is

TIME_FORMAT=%Y-%m-%d

Use upper-case 'Y' for 4-digit years and lower-case 'y' for 2-digit years.

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

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...