回答編集履歴
3
推敲
test
CHANGED
|
@@ -8,7 +8,7 @@
|
|
|
8
8
|
|
|
9
9
|
TGNGSZIKAN = (
|
|
10
10
|
|
|
11
|
-
select format(higaval + lowval / 60 + lowval % 60, '00:00')
|
|
11
|
+
select format((higaval + lowval / 60) * 100 + lowval % 60, '00:00')
|
|
12
12
|
|
|
13
13
|
from (
|
|
14
14
|
|
2
推敲
test
CHANGED
|
@@ -25,3 +25,5 @@
|
|
|
25
25
|
)
|
|
26
26
|
|
|
27
27
|
```
|
|
28
|
+
|
|
29
|
+
※上記の例は時間は2桁なので適宜変更して下さい。
|
1
推敲
test
CHANGED
|
@@ -8,11 +8,11 @@
|
|
|
8
8
|
|
|
9
9
|
TGNGSZIKAN = (
|
|
10
10
|
|
|
11
|
-
select format(hival + lowval / 60 + lowval % 60, '00:00')
|
|
11
|
+
select format(higaval + lowval / 60 + lowval % 60, '00:00')
|
|
12
12
|
|
|
13
13
|
from (
|
|
14
14
|
|
|
15
|
-
select SUM(CONVERT(int,LEFT(TGNSTIME,2))) as hival
|
|
15
|
+
select SUM(CONVERT(int,LEFT(TGNSTIME,2))) as highval
|
|
16
16
|
|
|
17
17
|
, SUM(CONVERT(int,RIGHT(TGNSTIME,2))) as lowval
|
|
18
18
|
|