SQL 日。年。月。星期
2011-03-24 18:55 沐海 阅读(239) 评论(0) 编辑 收藏 举报switch (selecttime)
{
case -1: where = "1=1";
break;
case 1: where = "Day(CreateTime)=Day(getdate())";
break;
case 2: where = "datepart(week,CreateTime)=datepart(week,getdate())";
break;
case 3: where = "month(CreateTime)=month(getdate())";
break;
case 4: where = "year(CreateTime)=year(getdate())";
break;
default:
break;
}
本人声明:
个人主页:沐海(http://www.cnblogs.com/mahaisong)
以上文章都是经过本人设计实践和阅读其他文档得出。如果需要探讨或指教可以留言或加我QQ!欢迎交流!