FOR SQL 2005: select datediff (day, birthdate, getdate())/365 from emp

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 / monal

Answer Posted / monal

FOR SQL 2005:

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is the primary use of the model database? : Sql server administration

962

Do you know spatial data types - geometry and geography in sql server 2008?

969

Define normalisation?

1060

What are sql server procedures?

928

Define Unique Key?

942

What is the difference between getdate and sysdatetime?

940

What types of Joins are possible with Sql Server?

1058

What is an expression in ms sql server?

1013

What new data source types were added in ssrs 2014?

153

Tell me the use of keyword with encryption. Create a store procedure with encryption?

961

What is buffer cash and log cache in sql server?

1054

How can sql server instances be hidden? : sql server security

1053

Do you know what are various aggregate functions that are available?

1015

What is the benefit of normalization?

1019

What is the difference between primary key and unique constraints?

901