we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz
- 6 Answers
- 8656 Views
- I also Faced
- E-Mail Answers
Answer Posted / santhi k
select trunc(months_between(Sysdate,EDOB)/12)Age from emp;
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What happens if date-only values are provided as date and time literals?
What is key attribute?
Explain about builtinadministrator?
What is difference between aggregate and analytic function?
Explain indexing and what are the advantages of it?
Why we use the openxml clause?
Difference between DELETE and TRUNCATE?
Why do we use non clustered index?
What is the report builder?
What does the not null constraint do?
What is database replication? What are the different types of replication you can set up in sql server?
why would you call update statistics? : Sql server database administration
How to enable tcp/ip protocol on a sql server?
What is collation sensitivity? Explain different types.
What is enhanced database mirroring in sql server 2008?
