Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Calculate age
"Liz J" <thejordanschangethistoanatsignclara.net> a écrit dans le message de news: 1142792170.381.0_at_dyke.uk.clara.net...
| If I have an entity Student and there is an attribute DOB holding the
| student's date of birth, how can I calculate his age today in years and
| months?
|
| Have been trying this but can't seem to get the syntax right.
|
| cheers
|
| Liz
|
|
Show us what you tried and we tell you what's wrong.
Btw, solution depends on Oracle version. It is mandatory to always include it in your posts.
Regards
Michel Cadot
Received on Sun Mar 19 2006 - 12:37:27 CST