//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