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!

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...