ST_X (Lakehouse v2)

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  │
└─────┘