top of page



ST_Longitude(p [, new_longitude_val])

With a single argument representing a valid Point object p that has a
geographic spatial reference system (SRS), ST_Longitude() returns the
longitude value of p as a double-precision number.

With the optional second argument representing a valid longitude value,
ST_Longitude() returns a Point object like the first argument with its
longitude equal to the second argument.

ST_Longitude() handles its arguments as described in the introduction
to this section, with the addition that if the Point object is valid
but does not have a geographic SRS, an ER_SRS_NOT_GEOGRAPHIC
tml#error_er_srs_not_geographic) error occurs.



mysql> SET @pt = ST_GeomFromText('POINT(45 90)', 4326);
mysql> SELECT ST_Longitude(@pt);
| ST_Longitude(@pt) |
| 90 |
mysql> SELECT ST_AsText(ST_Longitude(@pt, 10));
| ST_AsText(ST_Longitude(@pt, 10)) |
| POINT(45 10) |

bottom of page