mysql jion on月季_sql时间查询按月季年（1）

最新推荐文章于 2022-03-16 22:56:19 发布

利兄

最新推荐文章于 2022-03-16 22:56:19 发布

阅读量160

点赞数

文章标签： mysql jion on月季

本文链接：https://blog.csdn.net/weixin_33078391/article/details/113281328

版权

查询本日的记录 select * from tableName where DATEPART(dd, theDate) = DATEPART(dd, GETDATE()) and DATEPART(mm, theDate) = DATEPART(mm, GETDATE()) and DATEPART(yy, theDate) = DATEPART(yy, GETDATE()) 查询本月的记录 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())

查询 n 天前的记录 select * from tableName where DATEDIFF(DAY,theDate,GETDATE())=n

查询 n 年前的记录 select * from tableName where DATEDIFF(Year,theDate,GETDATE())=n

查询 n 月前的记录 select * from tableName where DATEDIFF(Month,theDate,GETDATE())=n

=====================