i have a time field and i want to extract date from it in my elasticsearch sql query.
Below is the format of time: 2020-01-11T02:13:00.000Z
which function in elasticsearch sql query will extract the date from it.
I am using date_part function but its not return the date
"DATE_PART('date', time) AS logindate"
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.