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
9688 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 encryption of entire databases without the need for application changes in sql server 2008?

1046

What are acid properties of transaction?

949

What is merge replication?

1105

Write query to return all rows sql?

1056

what is the main function of a query parameter?

152

Explain a checkpoint?

1040

Explain indexes disadvantages?

1086

What is default port number for sql server 2000?

1049

What are the advantages to use stored procedures?

1110

Can we use where clause in union?

1069

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1075

What is query cost in sql server?

995

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2027

How do I know if localdb is running?

954

How can a user-defined datatype be created?

985