SQL+C#实现获得当前月的第一天与最后一天
时间:2021-04-02 09:45:07|栏目:.NET代码|点击: 次
话不多说,请看下面
//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 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
栏 目:.NET代码
下一篇:关于C# 5.0 CallerMemberName CallerFilePath CallerLineNumber 在.NET4中的使用介绍方法
本文地址:http://www.codeinn.net/misctech/92725.html






