取当前时间:
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2011-08-08 13:59:30 |
+---------------------+
前一小时的时间:
mysql> select date_sub(now(), interval 1 hour);
+----------------------------------+
| date_sub(now(), interval 1 hour) |
+----------------------------------+
| 2011-08-08 12:59:31 |
+----------------------------------+
后一小时的时间:
mysql> select date_add(now(), interval 1 hour);
+----------------------------------+
| date_add(now(), interval 1 hour) |
+----------------------------------+
| 2011-08-08 14:59:50 |
+----------------------------------+
转载:https://blog.csdn.net/z13197919100/article/details/79236048?utm_source=blogxgwz1