display your age in months?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the update statement in sql

726


how to use regular expression in pattern match conditions? : Sql dba

730


What is sqlite used for?

695


How do rank () and dense_rank () differ?

715


What is cost in sql execution plan?

676






What is the command used to fetch first 5 characters of the string?

1089


What are the various levels of constraints?

851


explain the delete statements in sql

744


What are the different schemas objects that can be created using pl/sql?

720


What is the use of %rowtype?

739


How many columns should be in an index?

703


What is the use of & in pl sql?

720


explain mysql aggregate functions. : Sql dba

721


How do you concatenate in sql?

722


What is loop in pl sql?

759