Home Forums SQL Server 2008 SQL Server 2008 - General Difference count RE: Difference count
ramrajan
SSCommitted
Points: 1737
More actions
September 4, 2015 at 5:48 am
#1824599
declare @startdate datetime = '2015-03-31 23:59:59.097';
declare @enddate datetime = '2015-04-01 00:00:00.000';
returns 2
Awesome simplified solution with SELECT DATEDIFF(Year, @startdate, @enddate) + 1 AS QUARTER_DIFFERENCE