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

[jwalzerpitt]

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

[richgalloway · Accepted solution]

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.