首页
后端开发
C#
ASP.NET查询本月本周本季

ASP.NET查询本月本周本季

14 次浏览 0 条评论
txt
txt
查询本月的记录select * from tableName where DATEPART(mm, theDate) = DATEPART(mm, GETDATE()) and DATEPART(yy, theDate) = DATEPART(yy, GETDATE())查询本周的记录select * from tableName where DATEPART(wk, theDate) = DATEPART(wk, GETDATE()) and DATEPART(yy, theDate) = DATEPART(yy, GETDATE())查询本季的记录select * from tableName where DATEPART(qq, theDate) = DATEPART(qq, GETDATE()) and DATEPART(yy, theDate) = DATEPART(yy, GETDATE())其中:GETDATE()是获得系统时间的函数。
txt 文件大小：489B