回答編集履歴

1

加筆修正

2018/12/21 03:29

投稿

退会済みユーザー
test CHANGED
@@ -2,6 +2,14 @@
2
2
 
3
3
  ```
4
4
 
5
+ SELECT * FROM `book`
6
+
5
- SELECT * FROM `book` WHERE dat BETWEEN TIMESTAMP('2018-12-21 00:00:00') AND TIMESTAMP('2018-12-21 12:06:36')
7
+ WHERE `dat` BETWEEN TIMESTAMP('2018-12-21 00:00:00') AND TIMESTAMP('2018-12-21 12:06:36')
6
8
 
7
9
  ```
10
+
11
+
12
+
13
+ 参考:
14
+
15
+ [TIMESTAMP](https://dev.mysql.com/doc/refman/5.6/ja/date-and-time-functions.html#function_timestamp)