回答編集履歴

推敲

2020/08/11 11:42

投稿

スコア25430

answer CHANGED Viewed

@@ -3,7 +3,7 @@
 ```SQL
 UPDATE Goukei SET
 TGNGSZIKAN = (
-    select format(higaval + lowval / 60 + lowval % 60, '00:00')
+    select format((higaval + lowval / 60) * 100 + lowval % 60, '00:00')
     from (
         select SUM(CONVERT(int,LEFT(TGNSTIME,2))) as highval
              , SUM(CONVERT(int,RIGHT(TGNSTIME,2))) as lowval

推敲

2020/08/11 11:42

投稿

スコア25430

answer CHANGED Viewed

@@ -11,4 +11,5 @@
         WHERE TGNGNNO = Goukei.TGNGNNO
     ) step1
 )
-```
+```
+※上記の例は時間は2桁なので適宜変更して下さい。

推敲

2020/08/11 09:18

投稿

スコア25430

answer CHANGED Viewed

@@ -3,9 +3,9 @@
 ```SQL
 UPDATE Goukei SET
 TGNGSZIKAN = (
-    select format(hival + lowval / 60 + lowval % 60, '00:00')
+    select format(higaval + lowval / 60 + lowval % 60, '00:00')
     from (
-        select SUM(CONVERT(int,LEFT(TGNSTIME,2))) as hival
+        select SUM(CONVERT(int,LEFT(TGNSTIME,2))) as highval
              , SUM(CONVERT(int,RIGHT(TGNSTIME,2))) as lowval
         From Tantai
         WHERE TGNGNNO = Goukei.TGNGNNO