Need help to convert into date from string


(Manu) #1

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.

Thanks
Manu


(Brandon Kobel) #2

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.


(Manu) #3

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

Manu


(Brandon Kobel) #4

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


(Manu) #5

Thanks, I'll try with that.


(system) #6

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