Declare @Dt datetime='2012-02-04'select DAY(DATEADD(M,1,@Dt)-DAY(DATEADD(M,1,@Dt))) NoOfDays
Login to post response