如何在SQL中将Decimal坐标转换为GIS坐标？

Question

我把GIS坐标以十进制的形式存储在我们的一个系统里。但是，我想将它们显示为度:分:秒。我试着用谷歌搜索，但是找不到关于SQL的任何东西。谁能帮帮我？

    CREATE TABLE gis 
  ( 
     latitude DECIMAL(13, 10) 
  ); 

INSERT INTO gis 
SELECT -95.8833333000 
UNION ALL 
SELECT 32.5530555550 
UNION ALL 
SELECT -163.3000000000

谢谢!

Answer 1

我能够基于this blog做到这一点。希望这对将来的人有所帮助。

SELECT [Latitude] AS [Latitude], 
       CAST([Latitude] AS INT) AS [Degrees], 
       REPLACE(CAST(([Latitude] - CAST([Latitude] AS INT)) * 60 AS INT), '-', '') AS [Minutes], 
       REPLACE(CAST((3600 * ([Latitude] - CAST([Latitude] AS INT))) - (CAST(([Latitude] - CAST([Latitude] AS INT)) * 60 AS INT) * 60) AS INT), '-', '') AS [Seconds]
FROM gis