mysql 如何搜索当前时间前几分钟的数据

显示全部楼层 · 2010-3-1 11:19:10

select a from t1 where id=174 and id_1=2 and hourtime='now()- interval 50 hour';
结果如下：show warnings;
+---------+------+------------------------------------------------------------------------------------+
| Level | Code | Message
|
+---------+------+------------------------------------------------------------------------------------+
| Warning | 1292 | Incorrect datetime value: 'now()- interval 50 hour' for column 'hourtime' at row 1 |
| Warning | 1292 | Incorrect datetime value: 'now()- interval 50 hour' for column 'hourtime' at row 1 |
+---------+------+------------------------------------------------------------------------------------+

千问 · 2010-3-1 11:19:10

date_add(now(), interval 1 hour)

千问 · 2010-3-1 11:19:10

原帖由 strong_sjhi 于 2010-11-10 14:09 发表
date_add(now(), interval 1 hour)
now()如何显示当前时间属于哪一个小时
比如今天现在的 2010-11-09 14:16:42
如何用NOW()表示成 2010-11-09 14:00:00

千问 · 2010-3-1 11:19:10

Is this what you want?
mysql>select now(),DATE_SUB(now(),INTERVAL 10 SECOND);
+---------------------+------------------------------------+
| now()
| DATE_SUB(now(),INTERVAL 10 SECOND) |
+---------------------+------------------------------------+
| 2010-11-10 22:32:53 | 2010-11-10 22:32:43
|
+---------------------+------------------------------------+
1 row in set (0.00 sec)