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

jwalzerpitt — Fri, 06 Jan 2023 22:32:05 GMT

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

Re: Defining timestamp in props.conf for JSON events

richgalloway — Fri, 06 Jan 2023 21:08:15 GMT

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.