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!

Splunk APM & RUM | Upcoming Planned Maintenance

There will be planned maintenance of Splunk APM’s and Splunk RUM’s streaming infrastructure in the coming ...

Part 2: Diving Deeper With AIOps

Getting the Most Out of Event Correlation and Alert Storm Detection in Splunk IT Service Intelligence   Watch ...

User Groups | Upcoming Events!

If by chance you weren't already aware, the Splunk Community is host to numerous User Groups, organized ...