Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

months_between

319471Dec 3 2002
Hi, I am trying to write a script that will give me a person's age at a certain date. I have written the following:

trunc(months_between(socio.termdate,v3me.birthdate)/12,0)

the problem is if the termdate and the birthdate are the same month, the month of term isn't counted, so I'm getting a year less in age. How can I get around that?

Thanks so much for your help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2002
Added on Dec 3 2002
3 comments
176 views