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 a partition function in sql server?

1102

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1023

What is collation sensitivity?

1044

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

937

What are the events recorded in a transaction log?

982

Explain the dirty pages?

986

Do you know hot add cpu in sql server 2008?

941

Explain about service Broker functions?

1020

What is merge replication?

1093

What security features are available for stored procedure?

1015

What are locks in sql?

965

What is a trigger? Why we need it?

981

What is the difference between functions and scalar functions?

1191

Distinguish between commit and rollback?

943

How to throw custom exception in Stored Procedure?

1029