我想通过本周日期来查找记录。例如:
select datename(dw,getdate()) -- Example today is Friday "27-04-2012"
那么我该如何获取日期范围?
start on monday "23-04-2012" or sunday "22-04-2012" As @dateStart to
end on sunday "29-04-2012" or saturday "28-04-2012" As @dateEnd
那么我可以通过查询选择
select * from table where date>=@dateStart AND date<=@dateEnd