求大神指教,查询每天整点数据
create table tb(dt datetime)
insert into tb values('2009-02-24 01:00:01')
insert into tb values('2009-02-24 01:00:02')
insert into tb values('2009-02-24 01:00:03')
insert into tb values('2009-02-24 02:10:01')
insert into tb values('2009-02-24 02:10:03')
insert into tb values('2009-02-24 03:20:11')
insert into tb values('2009-02-24 03:03:01')
insert into tb values('2009-02-24 00:00:00')
insert into tb values('2009-02-25 00:00:00')
insert into tb values('2009-02-25 03:03:01')
go
求查询出结果如下
2009-02-24 00:00:00
2009-02-25 00:00:00