sql to get the dates of full years between two code example Example: sql get number of days between two dates DATEDIFF(DAY, '1/1/2011', '3/1/2011')