回答編集履歴
1
回答を修正
answer
CHANGED
|
@@ -1,6 +1,6 @@
|
|
|
1
1
|
```sql
|
|
2
2
|
SELECT * FROM playoff
|
|
3
|
-
WHERE start >= TIMESTAMP(ADDDATE(CURDATE(), 7))
|
|
3
|
+
WHERE start >= TIMESTAMP(ADDDATE(CURDATE(), 7), '12:00:00')
|
|
4
4
|
AND start < TIMESTAMP(ADDDATE(CURDATE(), 7), '13:00:00')
|
|
5
5
|
```
|
|
6
6
|
[https://dev.mysql.com/doc/refman/5.6/ja/date-and-time-functions.html](https://dev.mysql.com/doc/refman/5.6/ja/date-and-time-functions.html)
|