I'm trying to use a SQL query to get the Lat Long of points in a point layer in our geodatabase. The STAsText method will return the XY as shown below, but I'd like to get the lat long instead. Is there a method that can do this or is there a conversion I could use in SQL to convert the XY from STAsText?
Here is the query to get the XY:
select SHAPE, [SHAPE].STAsText() XY
Any help would be greatly appreciated. Thanks!