About
An aging or age report shows a metrics by the age of something where the date of birth is generally the start date of a process.
Example
Retention Rate
The metrics on week3 shows the number that are using the product and have signed-up three weeks ago.
Age calculation in Oracle
create table t ( x date );
Table created.
insert into t values ( to_date( '15-mar-1965', 'dd-mon-yyyy' ) );
1 row created.
select ( systimestamp - cast( x as timestamp ) ) year to month from t;
(SYSTIMESTAMP-CAST(XASTIMESTAMP))YEARTOMONTH
---------------------------------------------------------------------------
+44-01
select
trunc(months_between(sysdate,x)/12) years,
months_between(sysdate,x)-12*trunc(months_between(sysdate,x)/12) months
from t;
YEARS MONTHS
---------- ----------
44 1.05426971