Docs

Release notes
Troubleshoot
Reference

Get started
Solutions and use cases
Manage data
Explore and analyze
Deploy and manage
Manage your Cloud account and preferences
Troubleshoot
Extend and contribute
Release notes

Security
Observability
- Fields and object schemas
Elasticsearch and index management
Elastic Distributions of OpenTelemetry (EDOT)
Ingestion tools
Kibana
Elasticsearch plugins
Query languages
Scripting languages
- Painless
ECS reference
Data analysis
Search UI
Cloud
Glossary

Loading

Docs
/ Elastic Docs
/ …
/ SQL
/ Functions and operators
/

Cast operators

`Cast (::)`

:: provides an alternative syntax to the CAST function.

		SELECT '123'::long AS long;

      long
---------------
123

LIKE and RLIKE operators

9.0+ ✓
8.18

Edit this page
Report an issue

On this page

Cast (::)

Trademarks
Terms of Use
Privacy
Sitemap

© 2025 Elasticsearch B.V. All Rights Reserved.

Elasticsearch is a trademark of Elasticsearch B.V., registered in the U.S. and in other countries. 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.

Welcome to the docs for the latest Elastic product versions, including Elastic Stack 9.0 and Elastic Cloud Serverless. To view previous versions, go to elastic.co/guide.