回答編集履歴
1
修正
test
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
|
|
7
7
|
SELECT
|
|
8
8
|
|
|
9
|
-
DATE_FORMAT(A.`date`, '%Y-%m-%d %H:%
|
|
9
|
+
DATE_FORMAT(A.`date`, '%Y-%m-%d %H:%i') AS `dt`
|
|
10
10
|
|
|
11
11
|
, SUBSTRING_INDEX( GROUP_CONCAT(CAST(`value` AS CHAR) ORDER BY `date`), ',', 1 ) AS `first`
|
|
12
12
|
|
|
@@ -22,6 +22,6 @@
|
|
|
22
22
|
|
|
23
23
|
GROUP BY
|
|
24
24
|
|
|
25
|
-
DATE_FORMAT(A.`DATE`, '%Y-%m-%d %H:%
|
|
25
|
+
DATE_FORMAT(A.`DATE`, '%Y-%m-%d %H:%i')
|
|
26
26
|
|
|
27
27
|
```
|