LAST_DAY関数は？

無かったと思います declare @d datetime,@d2 datetime select @d = getdate() select @d2 = cast(year(@d) as char(4)) + '/' + cast(month(@d) as nvarchar(2)) + '/1' select dateadd(day,-1,(dateadd(month , 1, @d2 ))) as 当月末,@d as 今日 もっと簡素な方法があるかも

[neumann]

今月末： dateadd(day,-1,(dateadd(month , 1, cast(year(getdate()) as char(4)) + '/' + cast(month(getdate()) as nvarchar(2)) + '/1' )))　次月初め：dateadd(month , 1, cast(year(getdate()) as char(4)) + '/' + cast(month(getdate()) as nvarchar(2)) + '/1' )