回答編集履歴
1
加筆修正
answer
CHANGED
|
@@ -1,4 +1,8 @@
|
|
|
1
1
|
mysql民じゃないけど、datがTIMESTAMP型なら、TIMESTAMP型どうしで比較するべきです。
|
|
2
2
|
```
|
|
3
|
+
SELECT * FROM `book`
|
|
3
|
-
|
|
4
|
+
WHERE `dat` BETWEEN TIMESTAMP('2018-12-21 00:00:00') AND TIMESTAMP('2018-12-21 12:06:36')
|
|
4
|
-
```
|
|
5
|
+
```
|
|
6
|
+
|
|
7
|
+
参考:
|
|
8
|
+
[TIMESTAMP](https://dev.mysql.com/doc/refman/5.6/ja/date-and-time-functions.html#function_timestamp)
|