在开发过程中碰到了取当月的第一天和最后一天,在网上搜索了半天,找到一个在C#中和SQL语句的解决方法.
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 ) ) ;
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
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