Loading

Docs

Release notes
Troubleshoot
Reference

Elastic fundamentals
Solutions and use cases
Manage data
Explore and analyze
Deploy and manage
Manage your Cloud account and preferences
Troubleshoot
Release notes
Reference
Extend and contribute
Contribute to the docs

Elasticsearch
Kibana
Cloud
Security
Observability
- Fields and object schemas
- Infrastructure metrics reference
Ingestion tools
Elastic Common Schema (ECS)
Machine learning
- Kibana anomaly detection job wizards
- ML function reference
Search UI
Glossary

View as Markdown
Report a docs issue
Edit this page
Learn how to contribute

Get started free

14-day free trial
All features included
No setup required

Elastic Docs /
Reference /
Elasticsearch /
Query languages /
ES|QL /
Syntax reference /
Functions and operators

ES|QL type conversion functions

Tip

ES|QL supports implicit casting from string literals to certain data types. Refer to implicit casting for details.

ES|QL supports these type conversion functions:

TO_AGGREGATE_METRIC_DOUBLE
TO_BOOLEAN
TO_CARTESIANPOINT
TO_CARTESIANSHAPE
TO_DATEPERIOD
TO_DATETIME
TO_DATE_NANOS
TO_DEGREES
TO_DENSE_VECTOR
TO_DOUBLE
TO_GEOHASH
TO_GEOHEX
TO_GEOPOINT
TO_GEOSHAPE
TO_GEOTILE
TO_INTEGER
TO_IP
TO_LONG
TO_RADIANS
TO_STRING
TO_TDIGEST
TO_TIMEDURATION
TO_UNSIGNED_LONG
TO_VERSION

TO_AGGREGATE_METRIC_DOUBLE

Trademarks
Terms of Use
Privacy
Sitemap

© 2026 Elasticsearch B.V. All Rights Reserved.

This content is available in different formats for convenience only. All original licensing terms apply.

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.