Re: Calculating age of a person in PL/SQL

From: Hans Nesbø <hans.nesboe_at_selmer.skanska.no>
Date: Wed, 5 Sep 2001 21:24:01 +0200
Message-ID: <9n5u8b$4nr$1@pippin.skanska.se>

Or you can:
select to_char(sysdate,'YYYY') - to_char(birth_date,'YYYY') from ........

Best regards Hans

"Randi Wølner" <randiwolner_at_hotmail.com> skrev i melding news:9n4uc8$jnr$1_at_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 - 14:24:01 CDT