This is a cache of https://www.elastic.co/guide/en/elasticsearch/reference/8.19/sql-operators-cast.html. It is a snapshot of the page as it appeared on 2025-11-21T03:26:05.306+0000.
Cast Operators | Elasticsearch Guide [8.<strong>19</strong>] | Elastic
« Math Operators LIKE and RLIKE Operators »
Elastic Docs ›Elasticsearch Guide [8.19] ›SQL ›Functions and Operators

Cast Operators

edit
IMPORTANT: This documentation is no longer updated. Refer to Elastic's version policy and the latest documentation.

Cast Operators

edit

Cast (::)

edit

:: provides an alternative syntax to the CAST function.

SELECT '123'::long AS long;

      long
---------------
123
« Math Operators LIKE and RLIKE Operators »