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

6 Answers
9428 Views
I also Faced
E-Mail Answers

Answer Posted / santhi k

select trunc(months_between(Sysdate,EDOB)/12)Age from emp;

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain hostprotectionattribute in sql server 2005?

960

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

890

How will you know when statistics on a table are obsolete?

1032

Tell me what is log shipping?

935

What happens if ntwdblib.dll is missing on your machine?

1099

mention different types of relationships in the dbms?

963

Can we use having clause without group by?

930

Can we do dml on views?

914

What is named calculation? : sql server analysis services, ssas

931

What is @@rowcount in sql?

950

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

963

application server is slow what may be the problem

2165

What is save transaction and save point?

1120

Explain the various types of concurrency problem?

1136

How many replicas are maintained for each SQL Azure database?

140