select floor(months_between(sysdate,'22-mar-1995')) "age in

display your age in months?

Question Posted / sowmya makkena

Answer Posted / sowmya makkena

select floor(months_between(sysdate,'22-mar-1995')) "age in months" from dual;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is sql in mysql? : Sql dba

1123

What is a unique key?

1006

how to enter binary numbers in sql statements? : Sql dba

923

What is partition in sql query?

950

What is the maximum number of columns in sql table?

1089

What do you think about pl/sql?

950

What are the types of index in sql?

1016

What are the advantages of sql? Explain

1054

How do you remove duplicate records from a table?

887

Whis is not false in primary key?

1406

How do I run a program in pl sql?

952

What is consistency?

1062

What is parallel hint?

1223

What is delimiter sql?

924

Why is stored procedure faster than query?

909