declare @year int,@month int
set @year = 2004
set @month = 2
select dateadd(month,1,cast(@year as char(4))+'-'+cast(@month as varchar(2)) + '-01')-1/*
------------------------------------------------------
2004-02-29 00:00:00.000(所影响的行数为 1 行)
*/
set @year = 2004
set @month = 2
select dateadd(month,1,cast(@year as char(4))+'-'+cast(@month as varchar(2)) + '-01')-1/*
------------------------------------------------------
2004-02-29 00:00:00.000(所影响的行数为 1 行)
*/
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0))
select convert(nvarchar(10),cast('2004-03-01' as datetime)-1,120)
select @MonthDate = convert(char(10),dateadd(second, -1, dateadd(day, 1, getdate())),120)
print @MonthDate
select convert(nvarchar(10),cast('2004-03-01' as datetime)-1,102)
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0))