I read Difference between two DATETIMEs in ESSQL in Canvas (No script fields) that TIMESTAMPDIFF is not yet available for elasticsearch sql. I am wondering if there is another way to present time difference in my Canvas with datasource based on Elasticsearch query.
I have the same row with startTime and endTime. I would like to present overall time (endTime - startTime). Is it possible to make it:
- directly in elasticsearch sql without using TIMESTAMPDIFF
- using some function inside the Expression Editor in Canvas