display your age in months?

Question Posted / sowmya makkena

Answers were Sorted based on User's Feedback

display your age in months?..

Answer / sowmya makkena

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

Is This Answer Correct ?

1 Yes

0 No

display your age in months?..

select trunc(months_between(sysdate,'22-mar-1995')/12) as age from dual;

Is This Answer Correct ?

0 Yes

2 No

More SQL PLSQL Interview Questions

What is difference between ms sql and mysql?

How do you write a complex sql query?

How to display the contents of a current record fetched in a reference cursor?

what the meaning of sql

what are the different type of sql's statements ? : Sql dba

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

What is the difference between count 1 and count (*) in a sql query?

what is a unique key ? : Sql dba

what is indexing, searching and user interface?

how to see the create table statement of an existing table? : Sql dba

What is a mutating table

Can triggers stop a dml statement from executing on a table?

For more SQL PLSQL Interview Questions Click Here