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

How to run sql commands in sql*plus?

1188

What is procedure and function?

997

What is the non-clustered index in sql?

1066

How do I view a procedure in sql?

978

What is rollback?

1118

What is a database? Explain

1116

How do I view a sql trace file?

1035

how mysql optimizes distinct? : Sql dba

1083

What is a function in oracle pl sql?

1043

What is synchronized subquery?

1173

What are the commands used in sql?

1084

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1078

How do I create an index in word?

1037

What is error ora-12154: tns:could not resolve the connect identifier specified?

1084

What is function and procedure?

1037