select datediff(day,'1988-4-6','2010-08-30')--8181 days select datediff(month,'1988-4-6','2010-08-30')--268 months