1. select * from table where '1999-01-01 00:00:00' < time and '2003-01-01 00:00:00' > time;2. select * from table where UNIX_TIMESTAMP('1999-01-01 00:00:00') < UNIX_TIMESTAMP(time) and UNIX_TIMESTAMP('2003-01-01 00:00:00') > UNIX_TIMESTAMP(time);
SELECT * FROM Table WHERE (UNIX_TIMESTAMP(date) - UNIX_TIMESTAMP( "20030221" ) ) => 0 AND (UNIX_TIMESTAMP(date) - UNIX_TIMESTAMP( "20030224" ) ) =< 0;Table为你的数据库表名 20030221为时间点一 20030224为时间点二 得到的结果是在时间点一到时间点二的所有记录当然包括时间点一和二如果你不想要这两个时间点可以把SQL中的等号去掉。
1. select * from table where '1999-01-01 00:00:00' < time and '2003-01-01 00:00:00' > time;2. select * from table where UNIX_TIMESTAMP('1999-01-01 00:00:00') < UNIX_TIMESTAMP(time) and UNIX_TIMESTAMP('2003-01-01 00:00:00') > UNIX_TIMESTAMP(time);
FROM Table
WHERE
(UNIX_TIMESTAMP(date) - UNIX_TIMESTAMP( "20030221" ) ) => 0
AND
(UNIX_TIMESTAMP(date) - UNIX_TIMESTAMP( "20030224" ) ) =< 0;Table为你的数据库表名
20030221为时间点一
20030224为时间点二
得到的结果是在时间点一到时间点二的所有记录当然包括时间点一和二如果你不想要这两个时间点可以把SQL中的等号去掉。