CREATE TABLE `test`.`tA` ( `Id` int(6) unsigned NOT NULL auto_increment, `Name` national varchar(4) NOT NULL, `Time` timestamp(14) NOT NULL, PRIMARY KEY (`Id`) ) TYPE=MyISAM;INSERT INTO `ta` (`Name`) VALUES ('A'); INSERT INTO `ta` (`Name`) VALUES ('B'); INSERT INTO `ta` (`Name`) VALUES ('C');SELECT * FROM test.ta; +------+----------+------------------------------+ | Id | Name | Time | +------+----------+------------------------------+ | 1 | A | 20040909091032 | | 2 | B | 20040909091323 | | 3 | C | 20040909091331 | +------+----------+------------------------------+SELECT *, Now()FROM `test`.`ta` WHERE `Time` >= DATE_SUB(Now(), INTERVAL "4:0" MINUTE_SECOND); +------+----------+------------------------------+------------------------+ | Id | Name | Time | Now() | +------+----------+------------------------------+------------------------+ | 2 | B | 20040909091323 | 2004-09-09 09:16:27 | | 3 | C | 20040909091331 | 2004-09-09 09:16:27 | +------+----------+------------------------------+------------------------+
晕,不说了吗,我数据库里有一个日期和时间的字段呀to:shuixin13(犬犬(心帆)) 谢谢你,我的问题在你的提示的基础上解决了 方法是:select * from mmssub_dz where now()>=subdate and subdate>=DATE_SUB(Now(), INTERVAL "2:0" MINUTE_SECOND);其中subdate是我插入记录时的日期时间字段,谢谢各位啦!
`addtime` datetime default '0000-00-00 00:00:00',
`adduser` varchar(20) binary default NULL,
`updatetime` datetime default '0000-00-00 00:00:00',
`updateuser` varchar(20) binary default NULL,
+---------------------+-----------------------------------------------+
| Now() | DATE_SUB(Now(), INTERVAL "2:0" MINUTE_SECOND) |
+---------------------+-----------------------------------------------+
| 2004-09-09 09:08:10 | 2004-09-09 09:06:10 |
+---------------------+-----------------------------------------------+
`Id` int(6) unsigned NOT NULL auto_increment,
`Name` national varchar(4) NOT NULL,
`Time` timestamp(14) NOT NULL,
PRIMARY KEY (`Id`)
) TYPE=MyISAM;INSERT INTO `ta` (`Name`) VALUES ('A');
INSERT INTO `ta` (`Name`) VALUES ('B');
INSERT INTO `ta` (`Name`) VALUES ('C');SELECT * FROM test.ta;
+------+----------+------------------------------+
| Id | Name | Time |
+------+----------+------------------------------+
| 1 | A | 20040909091032 |
| 2 | B | 20040909091323 |
| 3 | C | 20040909091331 |
+------+----------+------------------------------+SELECT *, Now()FROM `test`.`ta` WHERE `Time` >= DATE_SUB(Now(), INTERVAL "4:0" MINUTE_SECOND);
+------+----------+------------------------------+------------------------+
| Id | Name | Time | Now() |
+------+----------+------------------------------+------------------------+
| 2 | B | 20040909091323 | 2004-09-09 09:16:27 |
| 3 | C | 20040909091331 | 2004-09-09 09:16:27 |
+------+----------+------------------------------+------------------------+
方法是:select * from mmssub_dz where now()>=subdate and subdate>=DATE_SUB(Now(), INTERVAL "2:0" MINUTE_SECOND);其中subdate是我插入记录时的日期时间字段,谢谢各位啦!