select datediff(m, '2012-04-01', getdate()) - case when d...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Materials Modeling Meta

Q&A for materials modelers and data scientists

select datediff(m, '2012-04-01', getdate()) -
case when day('2012-04-01') > day(getdate()) 
and day('2012-04-01') < getdate() then 1 else 0 end

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results