摘要:
select * from tbl where DATEPART(wk,date_field) = DATEPART(wk,getDate()) And DATEPART(yyyy,date_field) = DATEPART(yyyy,getDate())--周select * from tbl where DATEPART(m,date_field) = DATEPART(m,getDate()) And DATEPART(yyyy,date_field) = DATEPART(yyyy,getDate())--月select * from tbl where DATEPART(q,dat 阅读全文
posted @ 2013-05-14 10:41
摇摆的大叔
阅读(364)
评论(0)
推荐(1)


浙公网安备 33010602011771号