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

6 Answers
9696 Views
I also Faced
E-Mail Answers

Answer Posted / monal

FOR SQL 2005:

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

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

955

Where the sql logs gets stored? : sql server database administration

970

How to create an index on a view?

1070

How to get nth highest salary from employee table.

1163

How do we Backup SQL Azure Data?

108

What is the difference between dropping a database and taking a database offline?

1174

What new data source types were added in ssrs 2014?

160

What are user-defined functions (udfs) in sql server?

993

Can you leave a union at any time?

1063

How to update muliple row in single query?

1062

what is raid? : Sql server database administration

1045

Can we do dml on views?

960

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

968

How to generate create table script on an existing table in ms sql server?

1145

Explain comment on transactions?

1004