year diff

Question

how get year difference from store date to current date??? suppose my store date is 05/10/2005 and current date 04/10/2012.........so i want to get only year difference 7.

Vulpes · Answer

Try this: using System; class Test { static void Main() { DateTime store = new DateTime(2005 10 5); DateTime current = new DateTime(2012 10 4); int yearDiff = GetYearDiff(store current); Console.WriteLine(yearDiff); // 7 Console.ReadKey(); } static int GetYearDiff(DateTime dt1 DateTime dt2) { // express dates as days in an imaginary 372 day year with 12 x 31 day months int d1 = dt1.Year * 372 + (dt1.Month - 1) * 12 + dt1.Day - 1; dt2 = dt2.AddDays(1); // include last day in calculation int d2 = dt2.Year * 372 + (dt2.Month - 1) * 12 + dt2.Day - 1; return (d2 - d1)/372; } }

Raman Ghantiyala · Answer

hi vikas SELECT DATEDIFF(year '2005-12-31 23:59:59.9999999'  '2006-01-01 00:00:00.0000000');