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 does pl sql stand for?

1100

What is cascade in sql?

948

what is column? : Sql dba

990

How to move files from one directory to another in pl sql?

1173

What is a composite primary key?

1073

What is primary key in db?

993

What is record type in pl sql?

978

what is timestamp in mysql? : Sql dba

1056

Explian rowid, rownum? What are the psoducolumns we have?

989

Why plvtab is considered as the easiest way to access the pl/sql table?

1196

How to create a menu in sqlplus or pl/sql?

1105

What plvcmt and plvrb does in pl/sql?

1298

What is the difference between having and a where in sql?

1084

What is the difference between functions, procedures, and packages in pl/sql?

1028

Explain table and field in sql?

1051