本周时间的概念是上周六到本周五为一周
比如记录
id name bgTime
1 "test" 2013-08-07 14:12:30
2 "good" 2013-09-27 04:35:30
3 "suine" 2013-09-23 11:12:30
4 "ne" 2013-09-21 11:12:30
5 "sne" 2013-09-22 11:12:30
6 "unine" 2013-09-19 11:12:30
7 "shy" 2012-11-07 14:12:30
now.bgTime=2013-09-23 11:12:30
selsect id,name from a.table where bgTime in {本周}
理想结果:
2 "good" 2013-09-27 04:35:30
3 "suine" 2013-09-23 11:12:30
4 "ne" 2013-09-21 11:12:30
5 "sne" 2013-09-22 11:12:30