标准SQL语句 如何取出一天时间内的数据 时间是Timestamp？？

[noobie]

各位高手~如题~~

[懒得去死]

create table lk10(
id int not null auto_increment primary key,
t_time timestamp
);
insert into lk10(t_time) values
(now()),
(date_add(now(),interval 2 second)),
(date_add(now(),interval 2 minute)),
(date_add(now(),interval 2 day)),
(date_add(now(),interval 2 month)),
(date_add('2007-10-12',interval 2 second))

select * from lk10 where day(t_time) = day(now());


query result(4 records)
id t_time 
1 2007-10-25 13:55:36 
2 2007-10-25 13:55:38 
3 2007-10-25 13:57:36 
5 2007-12-25 13:55:36 

[noobie]

CREATE TABLE research
(
currenttime bigint NOT NULL,
theme1 character varying(20) NOT NULL,
theme2 character varying NOT NULL,
ip character varying(20) NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
CONSTRAINT research_pkey PRIMARY KEY (currenttime)
)

我想取出从现在开始一天内的所有IP记录

[懒得去死]

不是都给你写了吗？
改一下不就行了。

[懒得去死]

select ip from research where day(`timestamp`) = day(now()) and `timestamp` < now();

[noobie]

要是10天内的呢？

[懒得去死]

select ip from research where `timestamp` >= date_sub(now(),interval 10 day) and `timestamp` < date_sub(now(),interval 10 day);