How best to calculate a persons age?

Hi to all,

What method would you all use to calculate someones age?

This is what I'm doing, just seems like there's gotta be a better way.
(and I'm not sure this is always accurate either)

ln_age := FLOOR((adt_cycle_date - ld_dob) / 365.25);


Thanks!

Where's the rest the story?

Code:

---

[email protected]L> select (sysdate - to_date('23/09/1970','dd/mm/yyyy')
)/365.25
  2  from dual
  3  /

(SYSDATE-TO_DATE('23/09/1970','DD/MM/YYYY'))/365.25
---------------------------------------------------
                                        32.8512056

---

Or if you want this...

Code:

---



SQL*Plus: Release 9.2.0.3.0 - Production on Wed Jul 30 21:45:18 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: appdev@nick920
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production

[email protected]> create table t
  2  (name varchar2(30),
  3  dob date)
  4  /

Table created.

[email protected]> insert into t
  2  values('nick','10-06-2001')
  3  /
values('nick','10-06-2001')
              *
ERROR at line 2:
ORA-01843: not a valid month


[email protected]> insert into t
  2  values('nick','10-jun-01')
  3  /

1 row created.

[email protected]> select months_between(sysdate,dob)
  2  from t
  3  where name like 'ni%'
  4  /

MONTHS_BETWEEN(SYSDATE,DOB)
---------------------------
                  25.674471

[email protected]> /* or if you want in days, etc...*/
[email protected]>


[email protected]> select trunc(months_between(sysdate,dob)/12) years,
  2                                  mod(trunc(months_between(sysdate,dob)),12) months,
  3                                  sysdate - add_months(dob,trunc(months_between(sysdate,dob))) days
  4  from t
  5  where name like 'ni%'
  6  /

    YEARS    MONTHS      DAYS
---------- ---------- ----------
        2          1 20.9149537

[email protected]>

---

Quote:

---

Originally posted by RBC
How best to calculate a persons age?

---

Cut them in half an count the rings. Or do you want a non destructive method?

And look, you even get a wrong date format tossed in for free! Now, that is what makes this board such a great place.

wow, thanks for the effort!

Here's what I've changed it to so far.
ln_age := FLOOR(MONTHS_BETWEEN(adt_cycle_date,ld_dob)/12);

I can't find errors with this (so far...)

Thanks again!

Oh.. Ok, Glad to be able to help...;)

Calculate an age when, over which years? There is the issue of missing days in September, 1752...

Quote:

---

Originally posted by DaPi
Cut them in half an count the rings. Or do you want a non destructive method?

---

ROTFL!!

Quote:

---

Originally posted by stecal
Calculate an age when, over which years? There is the issue of missing days in September, 1752...

---

I've got deja vu all over again.