ST_X
Learn how to use the ST_X spatial function in PlaidCloud Lakehouse. Returns the X coordinate (longitude) of a point geometry - with syntax and examples.
Returns the X coordinate (longitude) of a point geometry.
Analyze Syntax
func.st_x(<point>)
Analyze Examples
func.st_x(func.st_point(1.5, 2.5))
┌─────┐
│ 1.5 │
└─────┘
SQL Syntax
ST_X(<point>)
SQL Examples
SELECT ST_X(ST_POINT(1.5, 2.5));
┌─────┐
│ 1.5 │
└─────┘