datediff in sql

Jul 28 2010 3:31 AM
hi friends i am having two drop down lists one will be for hiredate and one more for the current date and i want the datediff between hiredate and current date in terms of year and months

for eg :(if total is 34 months) then i want as output is 2 years and 10 months

Answers (2)