Date Fields from PostgreSQL view get muddled in Index Pattern Search

Siren Platform/Investigate Tech Support Community
1

I am using a view in PostgreSQL and for the date information I format the timestamp to a ISO date to_char(time_informtion, 'YYYY-MM-DD HH24:MI:SS'::text).
This works great while building the Data Reflection Job.
However, if I create an Index Pattern Search based on the Data reflection, all the dates I have (starting Sep. 13, 2019) are displayed and interpreted as starting in January 2019.
Any help is greatly appreciated.

2

Could you please:

  • Provide mapping for the index.
  • Show one of the raw documents in question (Can be fetched via Dev Tools: GET ${index-name}/doc/${document-id}) and a screenshot of how it is being shown in the Ui.