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 are the differences between char and varchar in ms sql server?

1063

Explain the working of sql privileges?

1091

What is the stuff and how does it differ from the replace function?

1130

What is model database? : SQL Server Architecture

1130

How to name query output columns in ms sql server?

966

what is normalization? : Sql server database administration

1095

What is history table in sql server?

971

What is the difference between upgrade and migration in sql server?

1090

What is the command dbcc checkdb used for?

1010

Why do we use non clustered index?

1081

What is the difference between rank and dense_rank?

1084

What is the dbcc command and why is it used?

1052

Explain log shipping and mention its advantages.

1044

What are the properties of primary key?

974

do views contain data ?

965