How to find experience of person from date of joining to pre

Question

in detail Plz

Esakki Muthu · Answer

Hi narendar Try this Create table employee (empID IntName varchar(50)DOJ Datetime) insert into employee values(1'Arnold''2005-02-23') insert into employee values(2'Drekel''2009-08-2') insert into employee values(3'Frasher''2015-03-25') insert into employee values(4'Golavendor''2015-08-27') Query:1 SELECT p.empIDp.Namep.DOJ CASE WHEN DATEDIFF(Month p.DOJ GetDate()) WHEN DATEDIFF(Month p.DOJ GetDate()) > 36 THEN 'Above 3' END AS Exprience FROM employee p Query:2 SELECT p.empIDp.Namep.DOJ Convert(varchar(10) DATEDIFF(Month p.DOJ GetDate()) / 12) + ' Years ' + Convert(varchar(10) DATEDIFF(DAY p.DOJ GetDate()) % 30) + ' Months' FROM employee p

aditya immadi · Answer

http://stackoverflow.com/questions/2194999/how-to-calculate-an-age-based-on-a-birthday read carefully...u ll find u r answers for sure