ADD_MONTHS(s.dateofbirth,CEIL(MONTHS_BETWEEN(sysdate, s.dateofbirth)/12)*12)
Leap-day proof :)
This entry was posted by Onno on February 17, 2009 at 4:45 pm, and is filed under Programming. Follow any responses to this post through RSS 2.0.You can leave a response or trackback from your own site.
<a>
<abbr>
<acronym>
<b>
<blockquote>
<cite>
<code>
<del>
<em>
<i>
<q>
<strike>
<strong>
Didn't find any related posts :(
Lost your password?