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