いつも思い出せなくなるのでメモしておきます。 --先月の1日 select dateadd(m,-1,cast((cast(year(getdate()) as varchar(4))+'-'+ cast(month(getdate()) as varchar(2))+'-1') as datetime2)) --先月末 select dateadd(dd,-1,cast((cast(year(getdate()) as varchar(4))+'-'+ cast(month(getdate()) as varchar(2))+'-1') as datetime2)) --今月の1日 select cast((cast(year(getdate()) as varchar(4))+'-'+cast(month(getdate()) as varchar(2))+'-1') as datet