回答編集履歴
1
調整
test
CHANGED
|
@@ -8,11 +8,9 @@
|
|
|
8
8
|
|
|
9
9
|
(id int primary key,dt_str char(14),dt datetime as
|
|
10
10
|
|
|
11
|
-
(str_to_date(substr(dt_str,1,8),'%Y%m%d
|
|
11
|
+
(str_to_date(substr(dt_str,1,8),'%Y%m%d')
|
|
12
12
|
|
|
13
|
-
+interval time_to_sec(
|
|
13
|
+
+interval time_to_sec(substr(dt_str,9,4)*100) second);
|
|
14
|
-
|
|
15
|
-
);
|
|
16
14
|
|
|
17
15
|
|
|
18
16
|
|