1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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?..

Answer / siddharthapenchala

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

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

How to start oracle sql developer?

0 Answers  

What is sqlca in db2?

0 Answers  

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

What is anonymous block in sql?

0 Answers  




how would concatenate strings in mysql? : Sql dba

0 Answers  

What is recursive join in sql?

0 Answers  

What is the purpose of the sql select top clause?

0 Answers  

How sql query is executed?

0 Answers  

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

What are triggers and its uses?

0 Answers  

What is a stored procedure in sql with example?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories