How best to calculate a persons age?

[RBC]

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!

[Tarry]

Where's the rest the story?

[Tarry]

appdev@NICK817.TARRY.LOCAL> 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

[Tarry]

Or if you want this...

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

appdev@NICK920.US.ORACLE.COM> create table t
  2  (name varchar2(30),
  3  dob date)
  4  /

Table created.

appdev@NICK920.US.ORACLE.COM> 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


appdev@NICK920.US.ORACLE.COM> insert into t
  2  values('nick','10-jun-01')
  3  /

1 row created.

appdev@NICK920.US.ORACLE.COM> select months_between(sysdate,dob)
  2  from t
  3  where name like 'ni%'
  4  /

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

appdev@NICK920.US.ORACLE.COM> /* or if you want in days, etc...*/
appdev@NICK920.US.ORACLE.COM>


appdev@NICK920.US.ORACLE.COM> 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

appdev@NICK920.US.ORACLE.COM>

[DaPi]

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?

[stecal]

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

[RBC]

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!

[Tarry]

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

[stecal]

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

[marist89]

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

ROTFL!!