SqlServer 获取本周、本月、本季、本年的第一天和最后一天

--本周

select dateadd(WEEK, datediff(WEEK, 0, getdate()), 0);

select dateadd(WEEK, datediff(WEEK, 0, getdate()), 7);

--本月

select dateadd(month, datediff(month, 0, getdate()), 0);

select dateadd(month, datediff(month, -1, getdate()), -1);

--本季

select dateadd(QUARTER , datediff(QUARTER ,0, getdate()), 0);

select dateadd(QUARTER , datediff(QUARTER , -1, getdate()), -1);

--本年

select dateadd(year, datediff(year, 0, getdate()), 0);

select dateadd(year, datediff(year, -1, getdate()), -1);

这回全了，Oracle和SqlServer的都有了