Convert geometry to lat and long

Question

I found in my database that shops location represented as geometry datatype.

Is it possible to convert to lat and long coordinates and use it as input for bing maps?

Answer 1

Jan 2020: The previous formats shown threw the following error:

OperationalError: (1054, "Unknown column 'geometry_col.Long' in 'field list'")

However, this format worked:

SELECT ST_X(geometry_col) AS longitude,
       ST_Y(geometry_col) AS latitude
FROM yourTable;

Answer 2

This works for geometry types in sql server

SELECT  [Geometry].STX AS [Longitude],
    [Geometry].STY AS [Latitude]
FROM YourTable