display your age in months?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of count (*) in sql?

557


Why does sql need a server?

574


Write an sql query to select all records from the table?

569


Can we create view in stored procedure?

537


how would you get the current date in mysql? : Sql dba

560






what tools available for managing mysql server? : Sql dba

546


What is form and report?

529


How do you modify a column in sql?

546


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

497


How many types of primary keys are there?

540


What is before trigger?

566


How to display the records between two range in Oracle SQL Plus?

650


How do you rename a table in sql?

543


What is keys and its types?

554


what are the limitations of identity column? : Transact sql

617