select trunc(months_between(sysdate,'22-mar-1995')/12) as age fro

display your age in months?

Question Posted / siddharthapenchala

Answer Posted / siddharthapenchala

select trunc(months_between(sysdate,'22-mar-1995')/12) as age from dual;

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Where not exists in sql?

977

Enlist the advantages of sql.

1001

Explain the select statement in sql?

1109

What are actual parameters and formal parameters?

1103

What is out parameter used for eventhough return statement can also be used in pl/sql?

1077

What is count * in sql?

993

What is the use of index in hive?

1007

What is trigger point?

994

What is write ahead logging in sql server?

1049

How many aggregate functions are available there in sql?

983

What is an inner join sql?

1027

Can we use loop in sql?

967

What is posting?

1035

What is sql injection vulnerability?

943

how do you control the max size of a heap table? : Sql dba

978