select trunc(months_between(Sysdate,EDOB)/12)Age 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 / santhi k

Answer Posted / santhi k

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the template in sql?

1029

What is a partitioned view?

1052

List some advantages and disadvantages of stored procedure?

1063

What are the different kinds of ssrs reports?

221

Does sql server use t sql?

1071

What is buffer cash in sql server?

1206

Do you know the policy based administration feature of sql server 2008?

1002

Which tcp/ip port does the sql server run on? How can it be changed?

1113

Do you know how to implement service broker?

968

How to list all triggers in the database with sys.triggers in ms sql server?

1128

how many clustered indexes can be created on a table? : Sql server database administration

1223

What is the recommended total size of your memory optimized tables?

1005

What are SSL and TSL protocols?

1034

How to drop an existing table with "drop table" statements in ms sql server?

1147

What is sql server management studio? : sql server management studio

1126