📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

GEOHASH_DECODE



Converts a Geohash-encoded string into latitude/longitude coordinates.

Syntax

GEOHASH_DECODE('<geohashed-string\>')

Examples

SELECT GEOHASH_DECODE('ezs42'); ┌─────────────────────────────────┐ │ geohash_decode('ezs42') │ ├─────────────────────────────────┤ │ (-5.60302734375,42.60498046875) │ └─────────────────────────────────┘

Was this page helpful?