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

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

Answers

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

Narendar Narri

652

in detail Plz

Answers (2)

Next Recommended Forum

put sql result in 1 row

How to search date converted to nvarchar in sql statement

Forum Statistics

Please welcome our newest member zc y.
3,089,307 users have contributed to 147,411 threads and 483,542
In the past 24 hours, we have 4 new threads, 11 new posts, and 142 new users.
In last week, the most popular thread is 'Differences between .NET Framework, .NET Core, and .NET 5+ versions'.

Upcoming Events

View all

Auto-Archive Client Documents for Compliance: Automate Your Business Processes - Ep.6
Vibe Coding Bootcamp
Software Architecture Conference - 2025