If your want to remove the time portion of the result you could use this - select dateadd(month,datediff(month,-1,getdate()),0)