--月初日/月末日の取得DECLARE@DateDATETIME='2018/5/4 03:02:01';DECLARE@CONVERTCODEint=111;SELECTCONVERT(NVARCHAR,DATEADD(DAY,1-DATEPART(DAY,@Date),@Date),@CONVERTCODE)AS[当月月初],CONVERT(NVARCHAR,DATEADD(MONTH,-1,DATEADD(DAY,1-DATEPART(DAY,@Date),@Date)),@CONVERTCODE)AS[前月月初],CON...