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

How do you delete data from a table?

731

What is varchar data type in sql?

708

What is a pdo connection?

681

What is constant in pl sql?

706

What is null in pl/sql?

804

How can I see all tables in sql?

725

Are stored procedures compiled?

678

define join and explain different type of joins? : Sql dba

733

What are the two different parts of the pl/sql packages?

784

What are different methods to trace the pl/sql code?

738

Does access use sql?

747

How many functions are there in sql?

715

What does count (*) mean?

680

What are the parts of a sql statement?

760

explain advantages of innodb over myisam. : Sql dba

827