Re: Date function question

From: <yong321_at_yahoo.com>
Date: 2000/03/03
Message-ID: <89os9l$nuj$1@nnrp1.deja.com>#1/1

select to_char(sysdate,'yyyy')-to_char(dob,'yyyy') age from emp;

Yong Huang

(yong321_at_yahoo.com)
(http://www.stormloader.com/yonghuang/)

In article <89op0a$k27$1_at_nntp3.atl.mindspring.net>, "Abey Joseph" <abeyj_at_netzero.net> wrote:
> I am writing a report that shows a bunch of customer data. I need to
> extract the exact age of the customer. I am not sure if there is an
Oracle
> function that will give me the exact age. I subtracted the
date_of_birth
> from the sysdate and I get the number of days in between. How can I
then
> translate that to years and months? I can divide the days by 365, but
the
> margin of error gets bigger, the older the customer is. Any help is
> appreciated.
>
> Abey Joseph
> abeyj_at_netzero.net

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 03 2000 - 00:00:00 CST