唔愛吃蘋果 通过本文主要向大家介绍了c sql server,c sqlconnection,c语言嵌入式sql,c sql语句,c linq to sql等相关知识,希望对您有所帮助,也希望大家支持linkedu.com www.linkedu.com
话不多说,请看下面</div>
//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));</div>
//SQL代码 DECLARE @NOW DATETIME DECLARE @FistDayOfThisMonth DATETIME DECLARE @LastDayOfThisMonth DATETIME SET @NOW = GETDATE() SET @FistDayOfThisMonth = @NOW - DAY(@NOW) + 1 SET @LastDayOfThisMonth = DATEADD(MONTH, 1, @NOW - DAY(@NOW) + 1) - 1 SELECT @FistDayOfThisMonth SELECT @LastDayOfThisMonth</div>
以上就是本文的全部内容,希望对大家有所帮助,同时也希望多多支持!
</div>