摘要:
本周:select * from table where datediff(week,C_CALLTIME,getdate())=0 --C_CALLTIME 为日期字段 本月:select * from table where datediff(Month,C_CALLTIME,getdate())=0--C_CALLTIME 为日期字段 本季:select * from table where... 阅读全文
posted @ 2009-09-08 14:34 billpeng 阅读(196) 评论(0) 推荐(1) 编辑