查询某一天的数据:
select * from SubLink
where ttt
between dateadd(s,-1,'2008-9-4')and dateadd(s,-1,dateadd(d,1,'2008-9-4'))
结果如下
ID SubLinkName SubLinkURL LinKID ttt
----------- ------------------------------------------------------------------ ----------- -----------------------
2 子类目1B NULL 1 2008-09-04 01:00:00.000
3 子类目1C NULL 1 2008-09-04 23:12:12.000
6 子类目2C NULL 2 2008-09-04 00:00:01.000