we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to kn

Categories >> Software >> Databases >> SQL Server
Suggest New Category

we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz

Question Posted / reddy

6 Answers
9615 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age...

Answer / rajesh k. gupta

Hi,
In order to answer your question I would like to put all
three possible answers as follows:-

1.If You want to find out the age of employee as on the
date of Joining (Field name EDOJ) then Query will be

select *,datediff(year,EDOB,EDOJ) as Eage from emp

2. If you want to find out the age of employees as on
current date, query will be as follows:-

select *,datediff(year,EDOB,getdate()) from emp

3. If you want to find out age as on specific date stored
and taken from other variable then query will be :-

You need to declare a variable as datetime then need to
tore its value to it.

declare @dtb datetime
set @dtb='1990/01/10'
select *,datediff(year,EDOB,@dtb) from emp
---------------------------------------
For any clarification Please feel free to contact me.
Rajesh
9342284359

Is This Answer Correct ?

7 Yes

1 No

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age...

Answer / reddy

Thanks Rajesh K. Gupta.

Is This Answer Correct ?

4 Yes

0 No

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age...

Answer / monal

FOR SQL 2005:

select datediff (day, birthdate, getdate())/365 from emp

Is This Answer Correct ?

2 Yes

1 No

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age...

Answer / santhi k

Answer i submitted is for Oracle not for SQL server.
Sorry!
Plz always mention the RDBMS which you are using ,in the
post.
Bcoz,This Oracle query may not work in other RDBMS.

Is This Answer Correct ?

1 Yes

1 No

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age...

Answer / rajesh k. gupta

The answer submitted by Santhi K is wrong, Can shanti test
this query in sql server, because i ran it it does not
accept. there is no such months_between function

Is This Answer Correct ?

0 Yes

1 No

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age...

Answer / santhi k

select trunc(months_between(Sysdate,EDOB)/12)Age from emp;

Is This Answer Correct ?

0 Yes

2 No

Post New Answer