表如下：
username time
gigi 2004-4-1 8:27:15
gigi 2004-4-1 8:30:25
gigi 2004-4-1 15:30:21
gigi 2004-4-2 8:21:30
gigi 2004-4-2 17:30:20
allen 2004-4-1 8:27:15
allen 2004-4-1 8:30:15
allen 2004-4-1 9:30:25
allen 2004-4-1 17:30:21
allen 2004-4-2 8:21:30
allen 2004-4-2 17:30:20
.................
username字段记录所有的用户名，time字段记录每个人每天的时间
现在要从表中根据人名取出与他对应的某一段时间内每一天最早的时间和最晚的时间
请教各位该怎么做啊？
---------------------------------------------------------------
create table #1 (username varchar(20),[time] datetime)
insert into #1 values ('gigi','2004-4-1 8:27:15')
insert into #1 values ('gigi','2004-4-1 8:30:25')
insert into #1 values ('gigi','2004-4-1 15:30:21')
insert into #1 values ('gigi','2004-4-2 8:21:30')
insert into #1 values ('gigi','2004-4-2 17:30:20')
insert into #1 values ('allen','2004-4-1 8:27:15')
insert into #1 values ('allen','2004-4-1 8:30:15')
insert into #1 values ('allen','2004-4-1 9:30:25')
insert into #1 values ('allen','2004-4-1 17:30:21')
insert into #1 values ('allen','2004-4-2 8:21:30')
insert into #1 values ('allen','2004-4-2 17:30:20')
select username,maxtime=max([time]),mintime=min([time]) from #1 group by username,convert(varchar,[time],111) order by username
drop table #1