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

What are the different types of constraints?

1277

How to display the records between two range in Oracle SQL Plus?

1196

What is before and after trigger?

1010

Why do we use triggers?

1017

What do we need to check in database testing?

1063

How do you copy a table in sql?

1110

What is AUTH_ID and AUTH_USER in pl/sql ?

2236

What is right join sql?

1013

Difference between truncate, delete and drop commands?

1145

what is transaction? : Sql dba

1061

Which table is left in join?

1017

how can we submit a form without a submit button? : Sql dba

1036

Explain the difference between 'between' & 'and' operators in sql

1046

Why is sql better than hql?

1063

What is a unique key and primary key and foreign key?

1022