'opendistro/opensearch: equivalent of DATEDIFF() function?

I'm using the doc https://opendistro.github.io/for-elasticsearch-docs/docs/sql/functions/#date-and-time and https://opensearch.org/docs/latest/search-plugins/sql/functions/#date-and-time but haven't found any function like DATEDIFF() in elasticsearch.

I also tried the arithmetic operator with date typed column and it doesn't seem to work either (This query is not explainable):

SELECT timestamp(end_date) - timestamp(start_date) FROM <table>
sqldatetimeopensearchelasticsearch-opendistro


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions