SqlServer查询本月第一天,上月最后一天
普通:SELECT DATEADD(mm, DATEDIFF(m, 0, GETDATE()) - 1, 0) AS '上月第一天', DATEADD(ms, - 3, DATEADD(mm, DATEDIFF(m, 0, GETDATE()), 0)) AS '上月最后一天', DATEADD(mm, DATEDIFF(m, 0, GETDATE()), 0) AS '本月第一天', DA...
原创
2018-04-12 14:54:11 ·
4206 阅读 ·
0 评论