sql时间表按天计算一周

my table looks like this:

我的表看起来像这样:

select clocktime, for_UID, in1_out0 from timeclockentries

clocktime                   for_UID    in1_out0
2011-08-07 15:13:58.390 user193    1
2011-08-07 21:09:45.093 user193    0
2011-08-09 14:10:00.000 user193    1
2011-08-09 20:10:00.000 user193    0
select