SQL+C#实现获得当前月的第一天与最后一天

//C# 代码int year = DateTime.Now.Year;int month = DateTime.Now.Month;DateTime firstDayOfThisMonth = new DateTime(year, month, 1);DateTime lastDayOfThisMonth = new DateTime(year, month, DateTime.DaysInMonth(year, month));

//SQL代码DECLARE @NOW DATETIMEDECLARE @FistDayOfThisMonth DATETIME DECLARE @LastDayOfThisMonth DATETIMESET @NOW = GETDATE()SET @FistDayOfThisMonth = @NOW - DAY(@NOW) + 1 SET @LastDayOfThisMonth = DATEADD(MONTH, 1, @NOW - DAY(@NOW) + 1) - 1SELECT @FistDayOfThisMonthSELECT @LastDayOfThisMonth