質問編集履歴
1
SELECT文のDATE_FORMAT関数が抜けていたので修正しました
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -32,7 +32,7 @@
|
|
|
32
32
|
|
|
33
33
|
```SQL
|
|
34
34
|
SELECT
|
|
35
|
-
|
|
35
|
+
DATE_FORMAT(t.datehour,'%Y-%m-%d %H:00') AS 日付
|
|
36
36
|
,t.work AS 場所
|
|
37
37
|
,sum(t.stay_time) as 滞在時間計
|
|
38
38
|
FROM
|