取当前时间:
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 |
+
----------------------------------+