Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Calculating age of a person in PL/SQL

Calculating age of a person in PL/SQL

From: Randi Wølner <randiwolner_at_hotmail.com>
Date: Wed, 5 Sep 2001 12:21:58 +0200
Message-ID: <9n4uc8$jnr$1@oslo-nntp.eunet.no> 





What is the most efficient way of calculating a person's age at a certain
date?


I have to create a PL/SQL function for doing it, and first I tried using
MONTHS_BETWEEN and then dividing by 12,


but the result will be wrong for the month of  the persons's birthday..



I guess someone has done something like this before - and hope you'll
share..



Thanks,


Randi Wølner
Received on Wed Sep 05 2001 - 05:21:58 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US