質問編集履歴
1
書き間違えていました
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -7,7 +7,7 @@
|
|
|
7
7
|
+CAST(SPLIT("lat",',')[3] AS DECIMAL(10,7))/3600 AS latitude,
|
|
8
8
|
CAST(SPLIT("lon",',')[1] AS DECIMAL(10,7))
|
|
9
9
|
+CAST(SPLIT("lon",',')[2] AS DECIMAL(10,7))/60
|
|
10
|
-
+CAST(SPLIT("lon",',')[3] AS DECIMAL(10,7))/3600 AS
|
|
10
|
+
+CAST(SPLIT("lon",',')[3] AS DECIMAL(10,7))/3600 AS longitude,
|
|
11
11
|
WHERE
|
|
12
12
|
CAST(SPLIT("lat",',')[1] AS DECIMAL(10,7))
|
|
13
13
|
+CAST(SPLIT("lat",',')[2] AS DECIMAL(10,7))/60
|