When migrating Grafana from version 8.2.7 to 10.0.1, the tables no longer display the date/time configured in the Elasticsearch datasource (Time field name, for example field_data_a). This problem only happens in the “table” view.
When I changed the field to another (for example, field_data_b) it started displaying field_data_a correctly, but not field_data_b.
So I tested removing the [date_formats] settings, and everything worked again.
In other words, for Elasticsearch, changing the “full_date” configuration causes a conversion error.
It works:
full_date = YYYY-MM-DD HH:mm:ss
Does not work:
full_date = DD/MM/YYYY HH:mm:ss
It works, but the date is wrong:
full_date = DD-MM-YYYY HH:mm:ss (e.g. 2023-09-05 is converted to 2005 and not 2023)
Elasticsearch Version:
“version” : {
“number” : “7.4.0”,
…
}