<div>
Here's a link to a question I raised last week relating to date calculation, with some examples in the question of how you can calculate ages (but read the question as not all of them work, and I'm, still waiting to see if someone can give me an answer as to why!<br />
<br />
<a href="https://www.experts-exchange.com/questions/20808927/Interval-year-to-month-What-is-the-point.html" rel="ugc">https://www.experts-exchange.com/questions/20808927/Interval-year-to-month-What-is-the-point.html</a>
</div>


Here's a link to a question I raised last week relating to date calculation, with some examples in the question of how you can calculate ages (but read the question as not all of them work, and I'm, still waiting to see if someone can give me an answer as to why!

https://www.experts-exchange.com/questions/20808927/Interval-year-to-month-What-is-the-point.html [https://www.experts-exchange.com/questions/20808927/Interval-year-to-month-What-is-the-point.html]

<div>
<div class="content wysiwyg-content">
Hello,<br />
i am currently creating a member function in PLSQL and need to calculate the age of a person using the sysdate function. how can that be done? i am not sure how to split the sysdate to use only the year....<br />
<br />
thanx!!
</div>
</div>


Hello,
i am currently creating a member function in PLSQL and need to calculate the age of a person using the sysdate function. how can that be done? i am not sure how to split the sysdate to use only the year....

thanx!!

Need to calculate age in PLSQL using sysdate

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.