当月第一天 最后一天 C# SQL

C#

<!--<br><br>Code highlighting produced by Actipro CodeHighlighter (freeware)<br>http://www.CodeHighlighter.com/<br><br>-->intyear=DateTime.Now.Year;
intmonth=DateTime.Now.Month;

DateTimefirstDayOfThisMonth=newDateTime(year,month,1);
DateTimelastDayOfThisMonth=newDateTime(year,month,DateTime.DaysInMonth(year,month));

SQL

<!--<br><br>Code highlighting produced by Actipro CodeHighlighter (freeware)<br>http://www.CodeHighlighter.com/<br><br>-->DECLARE@NOWDATETIME
DECLARE@FistDayOfThisMonthDATETIME
DECLARE@LastDayOfThisMonthDATETIME

SET@NOW=GETDATE()
SET@FistDayOfThisMonth=@NOW-DAY(@NOW)+1
SET@LastDayOfThisMonth=DATEADD(MONTH,1,@NOW-DAY(@NOW)+1)-1

SELECT@FistDayOfThisMonth
SELECT@LastDayOfThisMonth