Need help to convert into date from string

Hi there,
I'm importing sql data into ES through some 3rd party software. While importing data from database to ES, it taking as string but I want this data as date datatype. May I know how to convert in Kibana uploaded data.


Hey @pingmehere you could use Kibana's Scripted Fields to convert the strings into dates, but it'll be much less performant than doing so on ingest.

Is there any other way to convert with high and good performance.


@pingmehere you could use the Reindex API in Elasticsearch to execute a script that converts to the Date field.

Thanks, I'll try with that.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.