we have strings in the format "2020-11-10T12:43:58" saved in Kibana.
When using ES SQL, we want to convert these strings into an integer or float so that the integer/float increases as the DateTime increases as well.
"2020-01-01T00:00:00" → 1
"2020-01-01T00:01:00" → 2
"2020-01-03T00:01:00" → 100
We want to add this new column to our SQL search result.
How can we do this?
Can someone show us an example, please?
With best regards