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 Int,Name 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.empID,p.Name,p.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.empID,p.Name,p.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

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

Answers (2)