Roberto Madro R.
asked on
Age Calculation from specific date
In a table that holds CustomerID, DOB, VisitDate, a customer can have multiple visits, I need to know what age was that customer at the last visit, both, the BOD and the VisitDate are Number datatype.
Thx
Thx
I'm NOT an Oracle guy, but . . .
Can't you just use something like
I know it going to return a decimal, but the whole number will be their age. You can cast/convert it as/if needed. I assume you'd get the correct age by selecting the appropriate visit date in your where clause.
Can't you just use something like
@DATEDIFF ('DD', visitdate, dob) / 365.25
I know it going to return a decimal, but the whole number will be their age. You can cast/convert it as/if needed. I assume you'd get the correct age by selecting the appropriate visit date in your where clause.
Without knowing what format the number is in, there is no way to know what it represents. If it is a Julian day, then no date math or conversion would be required.
ASKER
Datatype: Number
Length : 8
Format: YYYYMMDD
Length : 8
Format: YYYYMMDD
Assuming that there is no invalid data, this would work:
SELECT customerid,
dob,
visitdate,
Floor(Months_between(To_date(visit_date, 'yyyymmdd'),
To_date(dob, 'yyyymmdd'))
/ 12) age
FROM (SELECT customer_id,
dob,
visitdate,
Row_number()
over (
PARTITION BY customerid
ORDER BY visitdate DESC) rn
FROM mytab)
WHERE rn = 1;
If that doesn't work, please provide sample data.
Try like this.
SELECT CustomerID, MAX(CAST((TO_DATE(VisitDate,'yyyymmdd')-TO_DATE(DOB,'yyyymmdd'))/365 AS INT)) AS Age
FROM test1
GROUP BY CustomerID
ORDER BY CustomerID;
Sampledrop table test1;
create table test1(CustomerID int, DOB number, VisitDate number);
insert into test1 values (10,20000101,20160324);
insert into test1 values (10,20000101,20170425);
insert into test1 values (20,20000101,20160315);
insert into test1 values (20,20000101,20160321);
SELECT CustomerID, MAX(CAST((TO_DATE(VisitDate,'yyyymmdd')-TO_DATE(DOB,'yyyymmdd'))/365 AS INT)) AS Age
FROM test1
GROUP BY CustomerID
ORDER BY CustomerID;
/*
CUSTOMERID AGE
10 17
20 16
*/
ASKER
Sharath, I'm getting an ORA-01840: input value not long enough for date format. error.
ASKER
johnsone; apologies, the DOB field is in a different table, the CustomerID and VisitDate are in one, DOB is in another, but the 2 tables are linked via Primary Key of "CustomerID", both tables contain that field.
Then change the query. You should be able to handle changing it to two tables. If not, please provide structure and sample data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<< Sharath, I'm getting an ORA-01840: input value not long enough for date format. error.>>
You may be having incorrect data in your column. Could you post some sample data?
You may be having incorrect data in your column. Could you post some sample data?
PortletPaul,
Can you give an example of where the calculation that I posted would give incorrect results? Given the sample data that you posted, it gets the same results you did without all the extra math. If you are going to say someone's approach is inaccurate, please show how it is inaccurate.
Given the latest error message posted, this is all probably a dead issue as the dates are not stored in a date datatype and there appears to be invalid data.
Can you give an example of where the calculation that I posted would give incorrect results? Given the sample data that you posted, it gets the same results you did without all the extra math. If you are going to say someone's approach is inaccurate, please show how it is inaccurate.
Given the latest error message posted, this is all probably a dead issue as the dates are not stored in a date datatype and there appears to be invalid data.
I did not criticise any previously proposed code.
Saying that you need to compare the individual parts of the date is the accurate way to determine age, would imply that the other ways are inaccurate.
I have never used the floor based method mentioned above, but on prompting here is a comparison of results:
with Visits (id, CustomerID, visitdate) as (
select
1
, 101
, to_date('2016-01-01','yyyy-mm-dd')
from dual
union all
select
id + 1
, 101
, to_date('2016-01-01','yyyy-mm-dd') + ID
from Visits
where to_date('2016-01-01','yyyy-mm-dd') + ID < sysdate
)
, Customers as (
select 101 id, to_date('1976-02-29','yyyy-mm-dd') dob from dual
)
select
c.id
, c.dob
, v.visitdate
, CAST((VisitDate-DOB)/365 AS INT) as age_by_divide
, Floor(Months_between(visitdate,dob) / 12) age_by_floor
, EXTRACT(YEAR FROM v.VisitDate) - EXTRACT(YEAR FROM c.dob)
- ( CASE
WHEN EXTRACT(MONTH FROM c.dob) > EXTRACT(MONTH FROM v.VisitDate)
OR ( EXTRACT(MONTH FROM c.dob) = EXTRACT(MONTH FROM v.VisitDate)
AND EXTRACT(DAY FROM c.dob) > EXTRACT(DAY FROM v.VisitDate)
)
THEN 1
ELSE 0
END ) AS age_by_case
from Customers c
inner join Visits v on c.id = v.CustomerID
+-----+-----+---------------------+---------------------+---------------+--------------+-------------+
| | ID | DOB | VISITDATE | AGE_BY_DIVIDE | AGE_BY_FLOOR | AGE_BY_CASE |
+-----+-----+---------------------+---------------------+---------------+--------------+-------------+
| 425 | 101 | 29.02.1976 00:00:00 | 28.02.2017 00:00:00 | 41 | 41 | 40 |
+-----+-----+---------------------+---------------------+---------------+--------------+-------------+
| | ID | DOB | VISITDATE | AGE_BY_DIVIDE | AGE_BY_FLOOR | AGE_BY_CASE |
+-----+-----+---------------------+---------------------+---------------+--------------+-------------+
| 1 | 101 | 29.02.1976 00:00:00 | 01.01.2016 00:00:00 | 40 | 39 | 39 |
| 2 | 101 | 29.02.1976 00:00:00 | 02.01.2016 00:00:00 | 40 | 39 | 39 |
| 3 | 101 | 29.02.1976 00:00:00 | 03.01.2016 00:00:00 | 40 | 39 | 39 |
| 4 | 101 | 29.02.1976 00:00:00 | 04.01.2016 00:00:00 | 40 | 39 | 39 |
| 5 | 101 | 29.02.1976 00:00:00 | 05.01.2016 00:00:00 | 40 | 39 | 39 |
| 6 | 101 | 29.02.1976 00:00:00 | 06.01.2016 00:00:00 | 40 | 39 | 39 |
| 7 | 101 | 29.02.1976 00:00:00 | 07.01.2016 00:00:00 | 40 | 39 | 39 |
| 8 | 101 | 29.02.1976 00:00:00 | 08.01.2016 00:00:00 | 40 | 39 | 39 |
| 9 | 101 | 29.02.1976 00:00:00 | 09.01.2016 00:00:00 | 40 | 39 | 39 |
| 10 | 101 | 29.02.1976 00:00:00 | 10.01.2016 00:00:00 | 40 | 39 | 39 |
| 11 | 101 | 29.02.1976 00:00:00 | 11.01.2016 00:00:00 | 40 | 39 | 39 |
| 12 | 101 | 29.02.1976 00:00:00 | 12.01.2016 00:00:00 | 40 | 39 | 39 |
| 13 | 101 | 29.02.1976 00:00:00 | 13.01.2016 00:00:00 | 40 | 39 | 39 |
| 14 | 101 | 29.02.1976 00:00:00 | 14.01.2016 00:00:00 | 40 | 39 | 39 |
| 15 | 101 | 29.02.1976 00:00:00 | 15.01.2016 00:00:00 | 40 | 39 | 39 |
| 16 | 101 | 29.02.1976 00:00:00 | 16.01.2016 00:00:00 | 40 | 39 | 39 |
| 17 | 101 | 29.02.1976 00:00:00 | 17.01.2016 00:00:00 | 40 | 39 | 39 |
| 18 | 101 | 29.02.1976 00:00:00 | 18.01.2016 00:00:00 | 40 | 39 | 39 |
| 19 | 101 | 29.02.1976 00:00:00 | 19.01.2016 00:00:00 | 40 | 39 | 39 |
| 20 | 101 | 29.02.1976 00:00:00 | 20.01.2016 00:00:00 | 40 | 39 | 39 |
| 21 | 101 | 29.02.1976 00:00:00 | 21.01.2016 00:00:00 | 40 | 39 | 39 |
| 22 | 101 | 29.02.1976 00:00:00 | 22.01.2016 00:00:00 | 40 | 39 | 39 |
| 23 | 101 | 29.02.1976 00:00:00 | 23.01.2016 00:00:00 | 40 | 39 | 39 |
| 24 | 101 | 29.02.1976 00:00:00 | 24.01.2016 00:00:00 | 40 | 39 | 39 |
| 25 | 101 | 29.02.1976 00:00:00 | 25.01.2016 00:00:00 | 40 | 39 | 39 |
| 26 | 101 | 29.02.1976 00:00:00 | 26.01.2016 00:00:00 | 40 | 39 | 39 |
| 27 | 101 | 29.02.1976 00:00:00 | 27.01.2016 00:00:00 | 40 | 39 | 39 |
| 28 | 101 | 29.02.1976 00:00:00 | 28.01.2016 00:00:00 | 40 | 39 | 39 |
| 29 | 101 | 29.02.1976 00:00:00 | 29.01.2016 00:00:00 | 40 | 39 | 39 |
| 30 | 101 | 29.02.1976 00:00:00 | 30.01.2016 00:00:00 | 40 | 39 | 39 |
| 31 | 101 | 29.02.1976 00:00:00 | 31.01.2016 00:00:00 | 40 | 39 | 39 |
| 32 | 101 | 29.02.1976 00:00:00 | 01.02.2016 00:00:00 | 40 | 39 | 39 |
| 33 | 101 | 29.02.1976 00:00:00 | 02.02.2016 00:00:00 | 40 | 39 | 39 |
| 34 | 101 | 29.02.1976 00:00:00 | 03.02.2016 00:00:00 | 40 | 39 | 39 |
| 35 | 101 | 29.02.1976 00:00:00 | 04.02.2016 00:00:00 | 40 | 39 | 39 |
| 36 | 101 | 29.02.1976 00:00:00 | 05.02.2016 00:00:00 | 40 | 39 | 39 |
| 37 | 101 | 29.02.1976 00:00:00 | 06.02.2016 00:00:00 | 40 | 39 | 39 |
| 38 | 101 | 29.02.1976 00:00:00 | 07.02.2016 00:00:00 | 40 | 39 | 39 |
| 39 | 101 | 29.02.1976 00:00:00 | 08.02.2016 00:00:00 | 40 | 39 | 39 |
| 40 | 101 | 29.02.1976 00:00:00 | 09.02.2016 00:00:00 | 40 | 39 | 39 |
| 41 | 101 | 29.02.1976 00:00:00 | 10.02.2016 00:00:00 | 40 | 39 | 39 |
| 42 | 101 | 29.02.1976 00:00:00 | 11.02.2016 00:00:00 | 40 | 39 | 39 |
| 43 | 101 | 29.02.1976 00:00:00 | 12.02.2016 00:00:00 | 40 | 39 | 39 |
| 44 | 101 | 29.02.1976 00:00:00 | 13.02.2016 00:00:00 | 40 | 39 | 39 |
| 45 | 101 | 29.02.1976 00:00:00 | 14.02.2016 00:00:00 | 40 | 39 | 39 |
| 46 | 101 | 29.02.1976 00:00:00 | 15.02.2016 00:00:00 | 40 | 39 | 39 |
| 47 | 101 | 29.02.1976 00:00:00 | 16.02.2016 00:00:00 | 40 | 39 | 39 |
| 48 | 101 | 29.02.1976 00:00:00 | 17.02.2016 00:00:00 | 40 | 39 | 39 |
| 49 | 101 | 29.02.1976 00:00:00 | 18.02.2016 00:00:00 | 40 | 39 | 39 |
| 50 | 101 | 29.02.1976 00:00:00 | 19.02.2016 00:00:00 | 40 | 39 | 39 |
| 51 | 101 | 29.02.1976 00:00:00 | 20.02.2016 00:00:00 | 40 | 39 | 39 |
| 52 | 101 | 29.02.1976 00:00:00 | 21.02.2016 00:00:00 | 40 | 39 | 39 |
| 53 | 101 | 29.02.1976 00:00:00 | 22.02.2016 00:00:00 | 40 | 39 | 39 |
| 54 | 101 | 29.02.1976 00:00:00 | 23.02.2016 00:00:00 | 40 | 39 | 39 |
| 55 | 101 | 29.02.1976 00:00:00 | 24.02.2016 00:00:00 | 40 | 39 | 39 |
| 56 | 101 | 29.02.1976 00:00:00 | 25.02.2016 00:00:00 | 40 | 39 | 39 |
| 57 | 101 | 29.02.1976 00:00:00 | 26.02.2016 00:00:00 | 40 | 39 | 39 |
| 58 | 101 | 29.02.1976 00:00:00 | 27.02.2016 00:00:00 | 40 | 39 | 39 |
| 59 | 101 | 29.02.1976 00:00:00 | 28.02.2016 00:00:00 | 40 | 39 | 39 |
| 60 | 101 | 29.02.1976 00:00:00 | 29.02.2016 00:00:00 | 40 | 40 | 40 |
| 61 | 101 | 29.02.1976 00:00:00 | 01.03.2016 00:00:00 | 40 | 40 | 40 |
| 62 | 101 | 29.02.1976 00:00:00 | 02.03.2016 00:00:00 | 40 | 40 | 40 |
| 63 | 101 | 29.02.1976 00:00:00 | 03.03.2016 00:00:00 | 40 | 40 | 40 |
| 64 | 101 | 29.02.1976 00:00:00 | 04.03.2016 00:00:00 | 40 | 40 | 40 |
| 65 | 101 | 29.02.1976 00:00:00 | 05.03.2016 00:00:00 | 40 | 40 | 40 |
| 66 | 101 | 29.02.1976 00:00:00 | 06.03.2016 00:00:00 | 40 | 40 | 40 |
| 67 | 101 | 29.02.1976 00:00:00 | 07.03.2016 00:00:00 | 40 | 40 | 40 |
| 68 | 101 | 29.02.1976 00:00:00 | 08.03.2016 00:00:00 | 40 | 40 | 40 |
| 69 | 101 | 29.02.1976 00:00:00 | 09.03.2016 00:00:00 | 40 | 40 | 40 |
| 70 | 101 | 29.02.1976 00:00:00 | 10.03.2016 00:00:00 | 40 | 40 | 40 |
| 71 | 101 | 29.02.1976 00:00:00 | 11.03.2016 00:00:00 | 40 | 40 | 40 |
| 72 | 101 | 29.02.1976 00:00:00 | 12.03.2016 00:00:00 | 40 | 40 | 40 |
| 73 | 101 | 29.02.1976 00:00:00 | 13.03.2016 00:00:00 | 40 | 40 | 40 |
| 74 | 101 | 29.02.1976 00:00:00 | 14.03.2016 00:00:00 | 40 | 40 | 40 |
| 75 | 101 | 29.02.1976 00:00:00 | 15.03.2016 00:00:00 | 40 | 40 | 40 |
| 76 | 101 | 29.02.1976 00:00:00 | 16.03.2016 00:00:00 | 40 | 40 | 40 |
| 77 | 101 | 29.02.1976 00:00:00 | 17.03.2016 00:00:00 | 40 | 40 | 40 |
| 78 | 101 | 29.02.1976 00:00:00 | 18.03.2016 00:00:00 | 40 | 40 | 40 |
| 79 | 101 | 29.02.1976 00:00:00 | 19.03.2016 00:00:00 | 40 | 40 | 40 |
| 80 | 101 | 29.02.1976 00:00:00 | 20.03.2016 00:00:00 | 40 | 40 | 40 |
| 81 | 101 | 29.02.1976 00:00:00 | 21.03.2016 00:00:00 | 40 | 40 | 40 |
| 82 | 101 | 29.02.1976 00:00:00 | 22.03.2016 00:00:00 | 40 | 40 | 40 |
| 83 | 101 | 29.02.1976 00:00:00 | 23.03.2016 00:00:00 | 40 | 40 | 40 |
| 84 | 101 | 29.02.1976 00:00:00 | 24.03.2016 00:00:00 | 40 | 40 | 40 |
| 85 | 101 | 29.02.1976 00:00:00 | 25.03.2016 00:00:00 | 40 | 40 | 40 |
| 86 | 101 | 29.02.1976 00:00:00 | 26.03.2016 00:00:00 | 40 | 40 | 40 |
| 87 | 101 | 29.02.1976 00:00:00 | 27.03.2016 00:00:00 | 40 | 40 | 40 |
| 88 | 101 | 29.02.1976 00:00:00 | 28.03.2016 00:00:00 | 40 | 40 | 40 |
| 89 | 101 | 29.02.1976 00:00:00 | 29.03.2016 00:00:00 | 40 | 40 | 40 |
| 90 | 101 | 29.02.1976 00:00:00 | 30.03.2016 00:00:00 | 40 | 40 | 40 |
| 91 | 101 | 29.02.1976 00:00:00 | 31.03.2016 00:00:00 | 40 | 40 | 40 |
| 92 | 101 | 29.02.1976 00:00:00 | 01.04.2016 00:00:00 | 40 | 40 | 40 |
| 93 | 101 | 29.02.1976 00:00:00 | 02.04.2016 00:00:00 | 40 | 40 | 40 |
| 94 | 101 | 29.02.1976 00:00:00 | 03.04.2016 00:00:00 | 40 | 40 | 40 |
| 95 | 101 | 29.02.1976 00:00:00 | 04.04.2016 00:00:00 | 40 | 40 | 40 |
| 96 | 101 | 29.02.1976 00:00:00 | 05.04.2016 00:00:00 | 40 | 40 | 40 |
| 97 | 101 | 29.02.1976 00:00:00 | 06.04.2016 00:00:00 | 40 | 40 | 40 |
| 98 | 101 | 29.02.1976 00:00:00 | 07.04.2016 00:00:00 | 40 | 40 | 40 |
| 99 | 101 | 29.02.1976 00:00:00 | 08.04.2016 00:00:00 | 40 | 40 | 40 |
| 100 | 101 | 29.02.1976 00:00:00 | 09.04.2016 00:00:00 | 40 | 40 | 40 |
| 101 | 101 | 29.02.1976 00:00:00 | 10.04.2016 00:00:00 | 40 | 40 | 40 |
| 102 | 101 | 29.02.1976 00:00:00 | 11.04.2016 00:00:00 | 40 | 40 | 40 |
| 103 | 101 | 29.02.1976 00:00:00 | 12.04.2016 00:00:00 | 40 | 40 | 40 |
| 104 | 101 | 29.02.1976 00:00:00 | 13.04.2016 00:00:00 | 40 | 40 | 40 |
| 105 | 101 | 29.02.1976 00:00:00 | 14.04.2016 00:00:00 | 40 | 40 | 40 |
| 106 | 101 | 29.02.1976 00:00:00 | 15.04.2016 00:00:00 | 40 | 40 | 40 |
| 107 | 101 | 29.02.1976 00:00:00 | 16.04.2016 00:00:00 | 40 | 40 | 40 |
| 108 | 101 | 29.02.1976 00:00:00 | 17.04.2016 00:00:00 | 40 | 40 | 40 |
| 109 | 101 | 29.02.1976 00:00:00 | 18.04.2016 00:00:00 | 40 | 40 | 40 |
| 110 | 101 | 29.02.1976 00:00:00 | 19.04.2016 00:00:00 | 40 | 40 | 40 |
| 111 | 101 | 29.02.1976 00:00:00 | 20.04.2016 00:00:00 | 40 | 40 | 40 |
| 112 | 101 | 29.02.1976 00:00:00 | 21.04.2016 00:00:00 | 40 | 40 | 40 |
| 113 | 101 | 29.02.1976 00:00:00 | 22.04.2016 00:00:00 | 40 | 40 | 40 |
| 114 | 101 | 29.02.1976 00:00:00 | 23.04.2016 00:00:00 | 40 | 40 | 40 |
| 115 | 101 | 29.02.1976 00:00:00 | 24.04.2016 00:00:00 | 40 | 40 | 40 |
| 116 | 101 | 29.02.1976 00:00:00 | 25.04.2016 00:00:00 | 40 | 40 | 40 |
| 117 | 101 | 29.02.1976 00:00:00 | 26.04.2016 00:00:00 | 40 | 40 | 40 |
| 118 | 101 | 29.02.1976 00:00:00 | 27.04.2016 00:00:00 | 40 | 40 | 40 |
| 119 | 101 | 29.02.1976 00:00:00 | 28.04.2016 00:00:00 | 40 | 40 | 40 |
| 120 | 101 | 29.02.1976 00:00:00 | 29.04.2016 00:00:00 | 40 | 40 | 40 |
| 121 | 101 | 29.02.1976 00:00:00 | 30.04.2016 00:00:00 | 40 | 40 | 40 |
| 122 | 101 | 29.02.1976 00:00:00 | 01.05.2016 00:00:00 | 40 | 40 | 40 |
| 123 | 101 | 29.02.1976 00:00:00 | 02.05.2016 00:00:00 | 40 | 40 | 40 |
| 124 | 101 | 29.02.1976 00:00:00 | 03.05.2016 00:00:00 | 40 | 40 | 40 |
| 125 | 101 | 29.02.1976 00:00:00 | 04.05.2016 00:00:00 | 40 | 40 | 40 |
| 126 | 101 | 29.02.1976 00:00:00 | 05.05.2016 00:00:00 | 40 | 40 | 40 |
| 127 | 101 | 29.02.1976 00:00:00 | 06.05.2016 00:00:00 | 40 | 40 | 40 |
| 128 | 101 | 29.02.1976 00:00:00 | 07.05.2016 00:00:00 | 40 | 40 | 40 |
| 129 | 101 | 29.02.1976 00:00:00 | 08.05.2016 00:00:00 | 40 | 40 | 40 |
| 130 | 101 | 29.02.1976 00:00:00 | 09.05.2016 00:00:00 | 40 | 40 | 40 |
| 131 | 101 | 29.02.1976 00:00:00 | 10.05.2016 00:00:00 | 40 | 40 | 40 |
| 132 | 101 | 29.02.1976 00:00:00 | 11.05.2016 00:00:00 | 40 | 40 | 40 |
| 133 | 101 | 29.02.1976 00:00:00 | 12.05.2016 00:00:00 | 40 | 40 | 40 |
| 134 | 101 | 29.02.1976 00:00:00 | 13.05.2016 00:00:00 | 40 | 40 | 40 |
| 135 | 101 | 29.02.1976 00:00:00 | 14.05.2016 00:00:00 | 40 | 40 | 40 |
| 136 | 101 | 29.02.1976 00:00:00 | 15.05.2016 00:00:00 | 40 | 40 | 40 |
| 137 | 101 | 29.02.1976 00:00:00 | 16.05.2016 00:00:00 | 40 | 40 | 40 |
| 138 | 101 | 29.02.1976 00:00:00 | 17.05.2016 00:00:00 | 40 | 40 | 40 |
| 139 | 101 | 29.02.1976 00:00:00 | 18.05.2016 00:00:00 | 40 | 40 | 40 |
| 140 | 101 | 29.02.1976 00:00:00 | 19.05.2016 00:00:00 | 40 | 40 | 40 |
| 141 | 101 | 29.02.1976 00:00:00 | 20.05.2016 00:00:00 | 40 | 40 | 40 |
| 142 | 101 | 29.02.1976 00:00:00 | 21.05.2016 00:00:00 | 40 | 40 | 40 |
| 143 | 101 | 29.02.1976 00:00:00 | 22.05.2016 00:00:00 | 40 | 40 | 40 |
| 144 | 101 | 29.02.1976 00:00:00 | 23.05.2016 00:00:00 | 40 | 40 | 40 |
| 145 | 101 | 29.02.1976 00:00:00 | 24.05.2016 00:00:00 | 40 | 40 | 40 |
| 146 | 101 | 29.02.1976 00:00:00 | 25.05.2016 00:00:00 | 40 | 40 | 40 |
| 147 | 101 | 29.02.1976 00:00:00 | 26.05.2016 00:00:00 | 40 | 40 | 40 |
| 148 | 101 | 29.02.1976 00:00:00 | 27.05.2016 00:00:00 | 40 | 40 | 40 |
| 149 | 101 | 29.02.1976 00:00:00 | 28.05.2016 00:00:00 | 40 | 40 | 40 |
| 150 | 101 | 29.02.1976 00:00:00 | 29.05.2016 00:00:00 | 40 | 40 | 40 |
| 151 | 101 | 29.02.1976 00:00:00 | 30.05.2016 00:00:00 | 40 | 40 | 40 |
| 152 | 101 | 29.02.1976 00:00:00 | 31.05.2016 00:00:00 | 40 | 40 | 40 |
| 153 | 101 | 29.02.1976 00:00:00 | 01.06.2016 00:00:00 | 40 | 40 | 40 |
| 154 | 101 | 29.02.1976 00:00:00 | 02.06.2016 00:00:00 | 40 | 40 | 40 |
| 155 | 101 | 29.02.1976 00:00:00 | 03.06.2016 00:00:00 | 40 | 40 | 40 |
| 156 | 101 | 29.02.1976 00:00:00 | 04.06.2016 00:00:00 | 40 | 40 | 40 |
| 157 | 101 | 29.02.1976 00:00:00 | 05.06.2016 00:00:00 | 40 | 40 | 40 |
| 158 | 101 | 29.02.1976 00:00:00 | 06.06.2016 00:00:00 | 40 | 40 | 40 |
| 159 | 101 | 29.02.1976 00:00:00 | 07.06.2016 00:00:00 | 40 | 40 | 40 |
| 160 | 101 | 29.02.1976 00:00:00 | 08.06.2016 00:00:00 | 40 | 40 | 40 |
| 161 | 101 | 29.02.1976 00:00:00 | 09.06.2016 00:00:00 | 40 | 40 | 40 |
| 162 | 101 | 29.02.1976 00:00:00 | 10.06.2016 00:00:00 | 40 | 40 | 40 |
| 163 | 101 | 29.02.1976 00:00:00 | 11.06.2016 00:00:00 | 40 | 40 | 40 |
| 164 | 101 | 29.02.1976 00:00:00 | 12.06.2016 00:00:00 | 40 | 40 | 40 |
| 165 | 101 | 29.02.1976 00:00:00 | 13.06.2016 00:00:00 | 40 | 40 | 40 |
| 166 | 101 | 29.02.1976 00:00:00 | 14.06.2016 00:00:00 | 40 | 40 | 40 |
| 167 | 101 | 29.02.1976 00:00:00 | 15.06.2016 00:00:00 | 40 | 40 | 40 |
| 168 | 101 | 29.02.1976 00:00:00 | 16.06.2016 00:00:00 | 40 | 40 | 40 |
| 169 | 101 | 29.02.1976 00:00:00 | 17.06.2016 00:00:00 | 40 | 40 | 40 |
| 170 | 101 | 29.02.1976 00:00:00 | 18.06.2016 00:00:00 | 40 | 40 | 40 |
| 171 | 101 | 29.02.1976 00:00:00 | 19.06.2016 00:00:00 | 40 | 40 | 40 |
| 172 | 101 | 29.02.1976 00:00:00 | 20.06.2016 00:00:00 | 40 | 40 | 40 |
| 173 | 101 | 29.02.1976 00:00:00 | 21.06.2016 00:00:00 | 40 | 40 | 40 |
| 174 | 101 | 29.02.1976 00:00:00 | 22.06.2016 00:00:00 | 40 | 40 | 40 |
| 175 | 101 | 29.02.1976 00:00:00 | 23.06.2016 00:00:00 | 40 | 40 | 40 |
| 176 | 101 | 29.02.1976 00:00:00 | 24.06.2016 00:00:00 | 40 | 40 | 40 |
| 177 | 101 | 29.02.1976 00:00:00 | 25.06.2016 00:00:00 | 40 | 40 | 40 |
| 178 | 101 | 29.02.1976 00:00:00 | 26.06.2016 00:00:00 | 40 | 40 | 40 |
| 179 | 101 | 29.02.1976 00:00:00 | 27.06.2016 00:00:00 | 40 | 40 | 40 |
| 180 | 101 | 29.02.1976 00:00:00 | 28.06.2016 00:00:00 | 40 | 40 | 40 |
| 181 | 101 | 29.02.1976 00:00:00 | 29.06.2016 00:00:00 | 40 | 40 | 40 |
| 182 | 101 | 29.02.1976 00:00:00 | 30.06.2016 00:00:00 | 40 | 40 | 40 |
| 183 | 101 | 29.02.1976 00:00:00 | 01.07.2016 00:00:00 | 40 | 40 | 40 |
| 184 | 101 | 29.02.1976 00:00:00 | 02.07.2016 00:00:00 | 40 | 40 | 40 |
| 185 | 101 | 29.02.1976 00:00:00 | 03.07.2016 00:00:00 | 40 | 40 | 40 |
| 186 | 101 | 29.02.1976 00:00:00 | 04.07.2016 00:00:00 | 40 | 40 | 40 |
| 187 | 101 | 29.02.1976 00:00:00 | 05.07.2016 00:00:00 | 40 | 40 | 40 |
| 188 | 101 | 29.02.1976 00:00:00 | 06.07.2016 00:00:00 | 40 | 40 | 40 |
| 189 | 101 | 29.02.1976 00:00:00 | 07.07.2016 00:00:00 | 40 | 40 | 40 |
| 190 | 101 | 29.02.1976 00:00:00 | 08.07.2016 00:00:00 | 40 | 40 | 40 |
| 191 | 101 | 29.02.1976 00:00:00 | 09.07.2016 00:00:00 | 40 | 40 | 40 |
| 192 | 101 | 29.02.1976 00:00:00 | 10.07.2016 00:00:00 | 40 | 40 | 40 |
| 193 | 101 | 29.02.1976 00:00:00 | 11.07.2016 00:00:00 | 40 | 40 | 40 |
| 194 | 101 | 29.02.1976 00:00:00 | 12.07.2016 00:00:00 | 40 | 40 | 40 |
| 195 | 101 | 29.02.1976 00:00:00 | 13.07.2016 00:00:00 | 40 | 40 | 40 |
| 196 | 101 | 29.02.1976 00:00:00 | 14.07.2016 00:00:00 | 40 | 40 | 40 |
| 197 | 101 | 29.02.1976 00:00:00 | 15.07.2016 00:00:00 | 40 | 40 | 40 |
| 198 | 101 | 29.02.1976 00:00:00 | 16.07.2016 00:00:00 | 40 | 40 | 40 |
| 199 | 101 | 29.02.1976 00:00:00 | 17.07.2016 00:00:00 | 40 | 40 | 40 |
| 200 | 101 | 29.02.1976 00:00:00 | 18.07.2016 00:00:00 | 40 | 40 | 40 |
| 201 | 101 | 29.02.1976 00:00:00 | 19.07.2016 00:00:00 | 40 | 40 | 40 |
| 202 | 101 | 29.02.1976 00:00:00 | 20.07.2016 00:00:00 | 40 | 40 | 40 |
| 203 | 101 | 29.02.1976 00:00:00 | 21.07.2016 00:00:00 | 40 | 40 | 40 |
| 204 | 101 | 29.02.1976 00:00:00 | 22.07.2016 00:00:00 | 40 | 40 | 40 |
| 205 | 101 | 29.02.1976 00:00:00 | 23.07.2016 00:00:00 | 40 | 40 | 40 |
| 206 | 101 | 29.02.1976 00:00:00 | 24.07.2016 00:00:00 | 40 | 40 | 40 |
| 207 | 101 | 29.02.1976 00:00:00 | 25.07.2016 00:00:00 | 40 | 40 | 40 |
| 208 | 101 | 29.02.1976 00:00:00 | 26.07.2016 00:00:00 | 40 | 40 | 40 |
| 209 | 101 | 29.02.1976 00:00:00 | 27.07.2016 00:00:00 | 40 | 40 | 40 |
| 210 | 101 | 29.02.1976 00:00:00 | 28.07.2016 00:00:00 | 40 | 40 | 40 |
| 211 | 101 | 29.02.1976 00:00:00 | 29.07.2016 00:00:00 | 40 | 40 | 40 |
| 212 | 101 | 29.02.1976 00:00:00 | 30.07.2016 00:00:00 | 40 | 40 | 40 |
| 213 | 101 | 29.02.1976 00:00:00 | 31.07.2016 00:00:00 | 40 | 40 | 40 |
| 214 | 101 | 29.02.1976 00:00:00 | 01.08.2016 00:00:00 | 40 | 40 | 40 |
| 215 | 101 | 29.02.1976 00:00:00 | 02.08.2016 00:00:00 | 40 | 40 | 40 |
| 216 | 101 | 29.02.1976 00:00:00 | 03.08.2016 00:00:00 | 40 | 40 | 40 |
| 217 | 101 | 29.02.1976 00:00:00 | 04.08.2016 00:00:00 | 40 | 40 | 40 |
| 218 | 101 | 29.02.1976 00:00:00 | 05.08.2016 00:00:00 | 40 | 40 | 40 |
| 219 | 101 | 29.02.1976 00:00:00 | 06.08.2016 00:00:00 | 40 | 40 | 40 |
| 220 | 101 | 29.02.1976 00:00:00 | 07.08.2016 00:00:00 | 40 | 40 | 40 |
| 221 | 101 | 29.02.1976 00:00:00 | 08.08.2016 00:00:00 | 40 | 40 | 40 |
| 222 | 101 | 29.02.1976 00:00:00 | 09.08.2016 00:00:00 | 40 | 40 | 40 |
| 223 | 101 | 29.02.1976 00:00:00 | 10.08.2016 00:00:00 | 40 | 40 | 40 |
| 224 | 101 | 29.02.1976 00:00:00 | 11.08.2016 00:00:00 | 40 | 40 | 40 |
| 225 | 101 | 29.02.1976 00:00:00 | 12.08.2016 00:00:00 | 40 | 40 | 40 |
| 226 | 101 | 29.02.1976 00:00:00 | 13.08.2016 00:00:00 | 40 | 40 | 40 |
| 227 | 101 | 29.02.1976 00:00:00 | 14.08.2016 00:00:00 | 40 | 40 | 40 |
| 228 | 101 | 29.02.1976 00:00:00 | 15.08.2016 00:00:00 | 40 | 40 | 40 |
| 229 | 101 | 29.02.1976 00:00:00 | 16.08.2016 00:00:00 | 40 | 40 | 40 |
| 230 | 101 | 29.02.1976 00:00:00 | 17.08.2016 00:00:00 | 40 | 40 | 40 |
| 231 | 101 | 29.02.1976 00:00:00 | 18.08.2016 00:00:00 | 40 | 40 | 40 |
| 232 | 101 | 29.02.1976 00:00:00 | 19.08.2016 00:00:00 | 40 | 40 | 40 |
| 233 | 101 | 29.02.1976 00:00:00 | 20.08.2016 00:00:00 | 41 | 40 | 40 |
| 234 | 101 | 29.02.1976 00:00:00 | 21.08.2016 00:00:00 | 41 | 40 | 40 |
| 235 | 101 | 29.02.1976 00:00:00 | 22.08.2016 00:00:00 | 41 | 40 | 40 |
| 236 | 101 | 29.02.1976 00:00:00 | 23.08.2016 00:00:00 | 41 | 40 | 40 |
| 237 | 101 | 29.02.1976 00:00:00 | 24.08.2016 00:00:00 | 41 | 40 | 40 |
| 238 | 101 | 29.02.1976 00:00:00 | 25.08.2016 00:00:00 | 41 | 40 | 40 |
| 239 | 101 | 29.02.1976 00:00:00 | 26.08.2016 00:00:00 | 41 | 40 | 40 |
| 240 | 101 | 29.02.1976 00:00:00 | 27.08.2016 00:00:00 | 41 | 40 | 40 |
| 241 | 101 | 29.02.1976 00:00:00 | 28.08.2016 00:00:00 | 41 | 40 | 40 |
| 242 | 101 | 29.02.1976 00:00:00 | 29.08.2016 00:00:00 | 41 | 40 | 40 |
| 243 | 101 | 29.02.1976 00:00:00 | 30.08.2016 00:00:00 | 41 | 40 | 40 |
| 244 | 101 | 29.02.1976 00:00:00 | 31.08.2016 00:00:00 | 41 | 40 | 40 |
| 245 | 101 | 29.02.1976 00:00:00 | 01.09.2016 00:00:00 | 41 | 40 | 40 |
| 246 | 101 | 29.02.1976 00:00:00 | 02.09.2016 00:00:00 | 41 | 40 | 40 |
| 247 | 101 | 29.02.1976 00:00:00 | 03.09.2016 00:00:00 | 41 | 40 | 40 |
| 248 | 101 | 29.02.1976 00:00:00 | 04.09.2016 00:00:00 | 41 | 40 | 40 |
| 249 | 101 | 29.02.1976 00:00:00 | 05.09.2016 00:00:00 | 41 | 40 | 40 |
| 250 | 101 | 29.02.1976 00:00:00 | 06.09.2016 00:00:00 | 41 | 40 | 40 |
| 251 | 101 | 29.02.1976 00:00:00 | 07.09.2016 00:00:00 | 41 | 40 | 40 |
| 252 | 101 | 29.02.1976 00:00:00 | 08.09.2016 00:00:00 | 41 | 40 | 40 |
| 253 | 101 | 29.02.1976 00:00:00 | 09.09.2016 00:00:00 | 41 | 40 | 40 |
| 254 | 101 | 29.02.1976 00:00:00 | 10.09.2016 00:00:00 | 41 | 40 | 40 |
| 255 | 101 | 29.02.1976 00:00:00 | 11.09.2016 00:00:00 | 41 | 40 | 40 |
| 256 | 101 | 29.02.1976 00:00:00 | 12.09.2016 00:00:00 | 41 | 40 | 40 |
| 257 | 101 | 29.02.1976 00:00:00 | 13.09.2016 00:00:00 | 41 | 40 | 40 |
| 258 | 101 | 29.02.1976 00:00:00 | 14.09.2016 00:00:00 | 41 | 40 | 40 |
| 259 | 101 | 29.02.1976 00:00:00 | 15.09.2016 00:00:00 | 41 | 40 | 40 |
| 260 | 101 | 29.02.1976 00:00:00 | 16.09.2016 00:00:00 | 41 | 40 | 40 |
| 261 | 101 | 29.02.1976 00:00:00 | 17.09.2016 00:00:00 | 41 | 40 | 40 |
| 262 | 101 | 29.02.1976 00:00:00 | 18.09.2016 00:00:00 | 41 | 40 | 40 |
| 263 | 101 | 29.02.1976 00:00:00 | 19.09.2016 00:00:00 | 41 | 40 | 40 |
| 264 | 101 | 29.02.1976 00:00:00 | 20.09.2016 00:00:00 | 41 | 40 | 40 |
| 265 | 101 | 29.02.1976 00:00:00 | 21.09.2016 00:00:00 | 41 | 40 | 40 |
| 266 | 101 | 29.02.1976 00:00:00 | 22.09.2016 00:00:00 | 41 | 40 | 40 |
| 267 | 101 | 29.02.1976 00:00:00 | 23.09.2016 00:00:00 | 41 | 40 | 40 |
| 268 | 101 | 29.02.1976 00:00:00 | 24.09.2016 00:00:00 | 41 | 40 | 40 |
| 269 | 101 | 29.02.1976 00:00:00 | 25.09.2016 00:00:00 | 41 | 40 | 40 |
| 270 | 101 | 29.02.1976 00:00:00 | 26.09.2016 00:00:00 | 41 | 40 | 40 |
| 271 | 101 | 29.02.1976 00:00:00 | 27.09.2016 00:00:00 | 41 | 40 | 40 |
| 272 | 101 | 29.02.1976 00:00:00 | 28.09.2016 00:00:00 | 41 | 40 | 40 |
| 273 | 101 | 29.02.1976 00:00:00 | 29.09.2016 00:00:00 | 41 | 40 | 40 |
| 274 | 101 | 29.02.1976 00:00:00 | 30.09.2016 00:00:00 | 41 | 40 | 40 |
| 275 | 101 | 29.02.1976 00:00:00 | 01.10.2016 00:00:00 | 41 | 40 | 40 |
| 276 | 101 | 29.02.1976 00:00:00 | 02.10.2016 00:00:00 | 41 | 40 | 40 |
| 277 | 101 | 29.02.1976 00:00:00 | 03.10.2016 00:00:00 | 41 | 40 | 40 |
| 278 | 101 | 29.02.1976 00:00:00 | 04.10.2016 00:00:00 | 41 | 40 | 40 |
| 279 | 101 | 29.02.1976 00:00:00 | 05.10.2016 00:00:00 | 41 | 40 | 40 |
| 280 | 101 | 29.02.1976 00:00:00 | 06.10.2016 00:00:00 | 41 | 40 | 40 |
| 281 | 101 | 29.02.1976 00:00:00 | 07.10.2016 00:00:00 | 41 | 40 | 40 |
| 282 | 101 | 29.02.1976 00:00:00 | 08.10.2016 00:00:00 | 41 | 40 | 40 |
| 283 | 101 | 29.02.1976 00:00:00 | 09.10.2016 00:00:00 | 41 | 40 | 40 |
| 284 | 101 | 29.02.1976 00:00:00 | 10.10.2016 00:00:00 | 41 | 40 | 40 |
| 285 | 101 | 29.02.1976 00:00:00 | 11.10.2016 00:00:00 | 41 | 40 | 40 |
| 286 | 101 | 29.02.1976 00:00:00 | 12.10.2016 00:00:00 | 41 | 40 | 40 |
| 287 | 101 | 29.02.1976 00:00:00 | 13.10.2016 00:00:00 | 41 | 40 | 40 |
| 288 | 101 | 29.02.1976 00:00:00 | 14.10.2016 00:00:00 | 41 | 40 | 40 |
| 289 | 101 | 29.02.1976 00:00:00 | 15.10.2016 00:00:00 | 41 | 40 | 40 |
| 290 | 101 | 29.02.1976 00:00:00 | 16.10.2016 00:00:00 | 41 | 40 | 40 |
| 291 | 101 | 29.02.1976 00:00:00 | 17.10.2016 00:00:00 | 41 | 40 | 40 |
| 292 | 101 | 29.02.1976 00:00:00 | 18.10.2016 00:00:00 | 41 | 40 | 40 |
| 293 | 101 | 29.02.1976 00:00:00 | 19.10.2016 00:00:00 | 41 | 40 | 40 |
| 294 | 101 | 29.02.1976 00:00:00 | 20.10.2016 00:00:00 | 41 | 40 | 40 |
| 295 | 101 | 29.02.1976 00:00:00 | 21.10.2016 00:00:00 | 41 | 40 | 40 |
| 296 | 101 | 29.02.1976 00:00:00 | 22.10.2016 00:00:00 | 41 | 40 | 40 |
| 297 | 101 | 29.02.1976 00:00:00 | 23.10.2016 00:00:00 | 41 | 40 | 40 |
| 298 | 101 | 29.02.1976 00:00:00 | 24.10.2016 00:00:00 | 41 | 40 | 40 |
| 299 | 101 | 29.02.1976 00:00:00 | 25.10.2016 00:00:00 | 41 | 40 | 40 |
| 300 | 101 | 29.02.1976 00:00:00 | 26.10.2016 00:00:00 | 41 | 40 | 40 |
| 301 | 101 | 29.02.1976 00:00:00 | 27.10.2016 00:00:00 | 41 | 40 | 40 |
| 302 | 101 | 29.02.1976 00:00:00 | 28.10.2016 00:00:00 | 41 | 40 | 40 |
| 303 | 101 | 29.02.1976 00:00:00 | 29.10.2016 00:00:00 | 41 | 40 | 40 |
| 304 | 101 | 29.02.1976 00:00:00 | 30.10.2016 00:00:00 | 41 | 40 | 40 |
| 305 | 101 | 29.02.1976 00:00:00 | 31.10.2016 00:00:00 | 41 | 40 | 40 |
| 306 | 101 | 29.02.1976 00:00:00 | 01.11.2016 00:00:00 | 41 | 40 | 40 |
| 307 | 101 | 29.02.1976 00:00:00 | 02.11.2016 00:00:00 | 41 | 40 | 40 |
| 308 | 101 | 29.02.1976 00:00:00 | 03.11.2016 00:00:00 | 41 | 40 | 40 |
| 309 | 101 | 29.02.1976 00:00:00 | 04.11.2016 00:00:00 | 41 | 40 | 40 |
| 310 | 101 | 29.02.1976 00:00:00 | 05.11.2016 00:00:00 | 41 | 40 | 40 |
| 311 | 101 | 29.02.1976 00:00:00 | 06.11.2016 00:00:00 | 41 | 40 | 40 |
| 312 | 101 | 29.02.1976 00:00:00 | 07.11.2016 00:00:00 | 41 | 40 | 40 |
| 313 | 101 | 29.02.1976 00:00:00 | 08.11.2016 00:00:00 | 41 | 40 | 40 |
| 314 | 101 | 29.02.1976 00:00:00 | 09.11.2016 00:00:00 | 41 | 40 | 40 |
| 315 | 101 | 29.02.1976 00:00:00 | 10.11.2016 00:00:00 | 41 | 40 | 40 |
| 316 | 101 | 29.02.1976 00:00:00 | 11.11.2016 00:00:00 | 41 | 40 | 40 |
| 317 | 101 | 29.02.1976 00:00:00 | 12.11.2016 00:00:00 | 41 | 40 | 40 |
| 318 | 101 | 29.02.1976 00:00:00 | 13.11.2016 00:00:00 | 41 | 40 | 40 |
| 319 | 101 | 29.02.1976 00:00:00 | 14.11.2016 00:00:00 | 41 | 40 | 40 |
| 320 | 101 | 29.02.1976 00:00:00 | 15.11.2016 00:00:00 | 41 | 40 | 40 |
| 321 | 101 | 29.02.1976 00:00:00 | 16.11.2016 00:00:00 | 41 | 40 | 40 |
| 322 | 101 | 29.02.1976 00:00:00 | 17.11.2016 00:00:00 | 41 | 40 | 40 |
| 323 | 101 | 29.02.1976 00:00:00 | 18.11.2016 00:00:00 | 41 | 40 | 40 |
| 324 | 101 | 29.02.1976 00:00:00 | 19.11.2016 00:00:00 | 41 | 40 | 40 |
| 325 | 101 | 29.02.1976 00:00:00 | 20.11.2016 00:00:00 | 41 | 40 | 40 |
| 326 | 101 | 29.02.1976 00:00:00 | 21.11.2016 00:00:00 | 41 | 40 | 40 |
| 327 | 101 | 29.02.1976 00:00:00 | 22.11.2016 00:00:00 | 41 | 40 | 40 |
| 328 | 101 | 29.02.1976 00:00:00 | 23.11.2016 00:00:00 | 41 | 40 | 40 |
| 329 | 101 | 29.02.1976 00:00:00 | 24.11.2016 00:00:00 | 41 | 40 | 40 |
| 330 | 101 | 29.02.1976 00:00:00 | 25.11.2016 00:00:00 | 41 | 40 | 40 |
| 331 | 101 | 29.02.1976 00:00:00 | 26.11.2016 00:00:00 | 41 | 40 | 40 |
| 332 | 101 | 29.02.1976 00:00:00 | 27.11.2016 00:00:00 | 41 | 40 | 40 |
| 333 | 101 | 29.02.1976 00:00:00 | 28.11.2016 00:00:00 | 41 | 40 | 40 |
| 334 | 101 | 29.02.1976 00:00:00 | 29.11.2016 00:00:00 | 41 | 40 | 40 |
| 335 | 101 | 29.02.1976 00:00:00 | 30.11.2016 00:00:00 | 41 | 40 | 40 |
| 336 | 101 | 29.02.1976 00:00:00 | 01.12.2016 00:00:00 | 41 | 40 | 40 |
| 337 | 101 | 29.02.1976 00:00:00 | 02.12.2016 00:00:00 | 41 | 40 | 40 |
| 338 | 101 | 29.02.1976 00:00:00 | 03.12.2016 00:00:00 | 41 | 40 | 40 |
| 339 | 101 | 29.02.1976 00:00:00 | 04.12.2016 00:00:00 | 41 | 40 | 40 |
| 340 | 101 | 29.02.1976 00:00:00 | 05.12.2016 00:00:00 | 41 | 40 | 40 |
| 341 | 101 | 29.02.1976 00:00:00 | 06.12.2016 00:00:00 | 41 | 40 | 40 |
| 342 | 101 | 29.02.1976 00:00:00 | 07.12.2016 00:00:00 | 41 | 40 | 40 |
| 343 | 101 | 29.02.1976 00:00:00 | 08.12.2016 00:00:00 | 41 | 40 | 40 |
| 344 | 101 | 29.02.1976 00:00:00 | 09.12.2016 00:00:00 | 41 | 40 | 40 |
| 345 | 101 | 29.02.1976 00:00:00 | 10.12.2016 00:00:00 | 41 | 40 | 40 |
| 346 | 101 | 29.02.1976 00:00:00 | 11.12.2016 00:00:00 | 41 | 40 | 40 |
| 347 | 101 | 29.02.1976 00:00:00 | 12.12.2016 00:00:00 | 41 | 40 | 40 |
| 348 | 101 | 29.02.1976 00:00:00 | 13.12.2016 00:00:00 | 41 | 40 | 40 |
| 349 | 101 | 29.02.1976 00:00:00 | 14.12.2016 00:00:00 | 41 | 40 | 40 |
| 350 | 101 | 29.02.1976 00:00:00 | 15.12.2016 00:00:00 | 41 | 40 | 40 |
| 351 | 101 | 29.02.1976 00:00:00 | 16.12.2016 00:00:00 | 41 | 40 | 40 |
| 352 | 101 | 29.02.1976 00:00:00 | 17.12.2016 00:00:00 | 41 | 40 | 40 |
| 353 | 101 | 29.02.1976 00:00:00 | 18.12.2016 00:00:00 | 41 | 40 | 40 |
| 354 | 101 | 29.02.1976 00:00:00 | 19.12.2016 00:00:00 | 41 | 40 | 40 |
| 355 | 101 | 29.02.1976 00:00:00 | 20.12.2016 00:00:00 | 41 | 40 | 40 |
| 356 | 101 | 29.02.1976 00:00:00 | 21.12.2016 00:00:00 | 41 | 40 | 40 |
| 357 | 101 | 29.02.1976 00:00:00 | 22.12.2016 00:00:00 | 41 | 40 | 40 |
| 358 | 101 | 29.02.1976 00:00:00 | 23.12.2016 00:00:00 | 41 | 40 | 40 |
| 359 | 101 | 29.02.1976 00:00:00 | 24.12.2016 00:00:00 | 41 | 40 | 40 |
| 360 | 101 | 29.02.1976 00:00:00 | 25.12.2016 00:00:00 | 41 | 40 | 40 |
| 361 | 101 | 29.02.1976 00:00:00 | 26.12.2016 00:00:00 | 41 | 40 | 40 |
| 362 | 101 | 29.02.1976 00:00:00 | 27.12.2016 00:00:00 | 41 | 40 | 40 |
| 363 | 101 | 29.02.1976 00:00:00 | 28.12.2016 00:00:00 | 41 | 40 | 40 |
| 364 | 101 | 29.02.1976 00:00:00 | 29.12.2016 00:00:00 | 41 | 40 | 40 |
| 365 | 101 | 29.02.1976 00:00:00 | 30.12.2016 00:00:00 | 41 | 40 | 40 |
| 366 | 101 | 29.02.1976 00:00:00 | 31.12.2016 00:00:00 | 41 | 40 | 40 |
| 367 | 101 | 29.02.1976 00:00:00 | 01.01.2017 00:00:00 | 41 | 40 | 40 |
| 368 | 101 | 29.02.1976 00:00:00 | 02.01.2017 00:00:00 | 41 | 40 | 40 |
| 369 | 101 | 29.02.1976 00:00:00 | 03.01.2017 00:00:00 | 41 | 40 | 40 |
| 370 | 101 | 29.02.1976 00:00:00 | 04.01.2017 00:00:00 | 41 | 40 | 40 |
| 371 | 101 | 29.02.1976 00:00:00 | 05.01.2017 00:00:00 | 41 | 40 | 40 |
| 372 | 101 | 29.02.1976 00:00:00 | 06.01.2017 00:00:00 | 41 | 40 | 40 |
| 373 | 101 | 29.02.1976 00:00:00 | 07.01.2017 00:00:00 | 41 | 40 | 40 |
| 374 | 101 | 29.02.1976 00:00:00 | 08.01.2017 00:00:00 | 41 | 40 | 40 |
| 375 | 101 | 29.02.1976 00:00:00 | 09.01.2017 00:00:00 | 41 | 40 | 40 |
| 376 | 101 | 29.02.1976 00:00:00 | 10.01.2017 00:00:00 | 41 | 40 | 40 |
| 377 | 101 | 29.02.1976 00:00:00 | 11.01.2017 00:00:00 | 41 | 40 | 40 |
| 378 | 101 | 29.02.1976 00:00:00 | 12.01.2017 00:00:00 | 41 | 40 | 40 |
| 379 | 101 | 29.02.1976 00:00:00 | 13.01.2017 00:00:00 | 41 | 40 | 40 |
| 380 | 101 | 29.02.1976 00:00:00 | 14.01.2017 00:00:00 | 41 | 40 | 40 |
| 381 | 101 | 29.02.1976 00:00:00 | 15.01.2017 00:00:00 | 41 | 40 | 40 |
| 382 | 101 | 29.02.1976 00:00:00 | 16.01.2017 00:00:00 | 41 | 40 | 40 |
| 383 | 101 | 29.02.1976 00:00:00 | 17.01.2017 00:00:00 | 41 | 40 | 40 |
| 384 | 101 | 29.02.1976 00:00:00 | 18.01.2017 00:00:00 | 41 | 40 | 40 |
| 385 | 101 | 29.02.1976 00:00:00 | 19.01.2017 00:00:00 | 41 | 40 | 40 |
| 386 | 101 | 29.02.1976 00:00:00 | 20.01.2017 00:00:00 | 41 | 40 | 40 |
| 387 | 101 | 29.02.1976 00:00:00 | 21.01.2017 00:00:00 | 41 | 40 | 40 |
| 388 | 101 | 29.02.1976 00:00:00 | 22.01.2017 00:00:00 | 41 | 40 | 40 |
| 389 | 101 | 29.02.1976 00:00:00 | 23.01.2017 00:00:00 | 41 | 40 | 40 |
| 390 | 101 | 29.02.1976 00:00:00 | 24.01.2017 00:00:00 | 41 | 40 | 40 |
| 391 | 101 | 29.02.1976 00:00:00 | 25.01.2017 00:00:00 | 41 | 40 | 40 |
| 392 | 101 | 29.02.1976 00:00:00 | 26.01.2017 00:00:00 | 41 | 40 | 40 |
| 393 | 101 | 29.02.1976 00:00:00 | 27.01.2017 00:00:00 | 41 | 40 | 40 |
| 394 | 101 | 29.02.1976 00:00:00 | 28.01.2017 00:00:00 | 41 | 40 | 40 |
| 395 | 101 | 29.02.1976 00:00:00 | 29.01.2017 00:00:00 | 41 | 40 | 40 |
| 396 | 101 | 29.02.1976 00:00:00 | 30.01.2017 00:00:00 | 41 | 40 | 40 |
| 397 | 101 | 29.02.1976 00:00:00 | 31.01.2017 00:00:00 | 41 | 40 | 40 |
| 398 | 101 | 29.02.1976 00:00:00 | 01.02.2017 00:00:00 | 41 | 40 | 40 |
| 399 | 101 | 29.02.1976 00:00:00 | 02.02.2017 00:00:00 | 41 | 40 | 40 |
| 400 | 101 | 29.02.1976 00:00:00 | 03.02.2017 00:00:00 | 41 | 40 | 40 |
| 401 | 101 | 29.02.1976 00:00:00 | 04.02.2017 00:00:00 | 41 | 40 | 40 |
| 402 | 101 | 29.02.1976 00:00:00 | 05.02.2017 00:00:00 | 41 | 40 | 40 |
| 403 | 101 | 29.02.1976 00:00:00 | 06.02.2017 00:00:00 | 41 | 40 | 40 |
| 404 | 101 | 29.02.1976 00:00:00 | 07.02.2017 00:00:00 | 41 | 40 | 40 |
| 405 | 101 | 29.02.1976 00:00:00 | 08.02.2017 00:00:00 | 41 | 40 | 40 |
| 406 | 101 | 29.02.1976 00:00:00 | 09.02.2017 00:00:00 | 41 | 40 | 40 |
| 407 | 101 | 29.02.1976 00:00:00 | 10.02.2017 00:00:00 | 41 | 40 | 40 |
| 408 | 101 | 29.02.1976 00:00:00 | 11.02.2017 00:00:00 | 41 | 40 | 40 |
| 409 | 101 | 29.02.1976 00:00:00 | 12.02.2017 00:00:00 | 41 | 40 | 40 |
| 410 | 101 | 29.02.1976 00:00:00 | 13.02.2017 00:00:00 | 41 | 40 | 40 |
| 411 | 101 | 29.02.1976 00:00:00 | 14.02.2017 00:00:00 | 41 | 40 | 40 |
| 412 | 101 | 29.02.1976 00:00:00 | 15.02.2017 00:00:00 | 41 | 40 | 40 |
| 413 | 101 | 29.02.1976 00:00:00 | 16.02.2017 00:00:00 | 41 | 40 | 40 |
| 414 | 101 | 29.02.1976 00:00:00 | 17.02.2017 00:00:00 | 41 | 40 | 40 |
| 415 | 101 | 29.02.1976 00:00:00 | 18.02.2017 00:00:00 | 41 | 40 | 40 |
| 416 | 101 | 29.02.1976 00:00:00 | 19.02.2017 00:00:00 | 41 | 40 | 40 |
| 417 | 101 | 29.02.1976 00:00:00 | 20.02.2017 00:00:00 | 41 | 40 | 40 |
| 418 | 101 | 29.02.1976 00:00:00 | 21.02.2017 00:00:00 | 41 | 40 | 40 |
| 419 | 101 | 29.02.1976 00:00:00 | 22.02.2017 00:00:00 | 41 | 40 | 40 |
| 420 | 101 | 29.02.1976 00:00:00 | 23.02.2017 00:00:00 | 41 | 40 | 40 |
| 421 | 101 | 29.02.1976 00:00:00 | 24.02.2017 00:00:00 | 41 | 40 | 40 |
| 422 | 101 | 29.02.1976 00:00:00 | 25.02.2017 00:00:00 | 41 | 40 | 40 |
| 423 | 101 | 29.02.1976 00:00:00 | 26.02.2017 00:00:00 | 41 | 40 | 40 |
| 424 | 101 | 29.02.1976 00:00:00 | 27.02.2017 00:00:00 | 41 | 40 | 40 |
| 425 | 101 | 29.02.1976 00:00:00 | 28.02.2017 00:00:00 | 41 | 41 | 40 |
| 426 | 101 | 29.02.1976 00:00:00 | 01.03.2017 00:00:00 | 41 | 41 | 41 |
| 427 | 101 | 29.02.1976 00:00:00 | 02.03.2017 00:00:00 | 41 | 41 | 41 |
| 428 | 101 | 29.02.1976 00:00:00 | 03.03.2017 00:00:00 | 41 | 41 | 41 |
| 429 | 101 | 29.02.1976 00:00:00 | 04.03.2017 00:00:00 | 41 | 41 | 41 |
| 430 | 101 | 29.02.1976 00:00:00 | 05.03.2017 00:00:00 | 41 | 41 | 41 |
| 431 | 101 | 29.02.1976 00:00:00 | 06.03.2017 00:00:00 | 41 | 41 | 41 |
| 432 | 101 | 29.02.1976 00:00:00 | 07.03.2017 00:00:00 | 41 | 41 | 41 |
| 433 | 101 | 29.02.1976 00:00:00 | 08.03.2017 00:00:00 | 41 | 41 | 41 |
| 434 | 101 | 29.02.1976 00:00:00 | 09.03.2017 00:00:00 | 41 | 41 | 41 |
| 435 | 101 | 29.02.1976 00:00:00 | 10.03.2017 00:00:00 | 41 | 41 | 41 |
| 436 | 101 | 29.02.1976 00:00:00 | 11.03.2017 00:00:00 | 41 | 41 | 41 |
| 437 | 101 | 29.02.1976 00:00:00 | 12.03.2017 00:00:00 | 41 | 41 | 41 |
| 438 | 101 | 29.02.1976 00:00:00 | 13.03.2017 00:00:00 | 41 | 41 | 41 |
| 439 | 101 | 29.02.1976 00:00:00 | 14.03.2017 00:00:00 | 41 | 41 | 41 |
| 440 | 101 | 29.02.1976 00:00:00 | 15.03.2017 00:00:00 | 41 | 41 | 41 |
| 441 | 101 | 29.02.1976 00:00:00 | 16.03.2017 00:00:00 | 41 | 41 | 41 |
| 442 | 101 | 29.02.1976 00:00:00 | 17.03.2017 00:00:00 | 41 | 41 | 41 |
| 443 | 101 | 29.02.1976 00:00:00 | 18.03.2017 00:00:00 | 41 | 41 | 41 |
| 444 | 101 | 29.02.1976 00:00:00 | 19.03.2017 00:00:00 | 41 | 41 | 41 |
| 445 | 101 | 29.02.1976 00:00:00 | 20.03.2017 00:00:00 | 41 | 41 | 41 |
| 446 | 101 | 29.02.1976 00:00:00 | 21.03.2017 00:00:00 | 41 | 41 | 41 |
| 447 | 101 | 29.02.1976 00:00:00 | 22.03.2017 00:00:00 | 41 | 41 | 41 |
| 448 | 101 | 29.02.1976 00:00:00 | 23.03.2017 00:00:00 | 41 | 41 | 41 |
| 449 | 101 | 29.02.1976 00:00:00 | 24.03.2017 00:00:00 | 41 | 41 | 41 |
| 450 | 101 | 29.02.1976 00:00:00 | 25.03.2017 00:00:00 | 41 | 41 | 41 |
| 451 | 101 | 29.02.1976 00:00:00 | 26.03.2017 00:00:00 | 41 | 41 | 41 |
| 452 | 101 | 29.02.1976 00:00:00 | 27.03.2017 00:00:00 | 41 | 41 | 41 |
| 453 | 101 | 29.02.1976 00:00:00 | 28.03.2017 00:00:00 | 41 | 41 | 41 |
| 454 | 101 | 29.02.1976 00:00:00 | 29.03.2017 00:00:00 | 41 | 41 | 41 |
| 455 | 101 | 29.02.1976 00:00:00 | 30.03.2017 00:00:00 | 41 | 41 | 41 |
| 456 | 101 | 29.02.1976 00:00:00 | 31.03.2017 00:00:00 | 41 | 41 | 41 |
| 457 | 101 | 29.02.1976 00:00:00 | 01.04.2017 00:00:00 | 41 | 41 | 41 |
| 458 | 101 | 29.02.1976 00:00:00 | 02.04.2017 00:00:00 | 41 | 41 | 41 |
| 459 | 101 | 29.02.1976 00:00:00 | 03.04.2017 00:00:00 | 41 | 41 | 41 |
| 460 | 101 | 29.02.1976 00:00:00 | 04.04.2017 00:00:00 | 41 | 41 | 41 |
| 461 | 101 | 29.02.1976 00:00:00 | 05.04.2017 00:00:00 | 41 | 41 | 41 |
| 462 | 101 | 29.02.1976 00:00:00 | 06.04.2017 00:00:00 | 41 | 41 | 41 |
| 463 | 101 | 29.02.1976 00:00:00 | 07.04.2017 00:00:00 | 41 | 41 | 41 |
| 464 | 101 | 29.02.1976 00:00:00 | 08.04.2017 00:00:00 | 41 | 41 | 41 |
| 465 | 101 | 29.02.1976 00:00:00 | 09.04.2017 00:00:00 | 41 | 41 | 41 |
| 466 | 101 | 29.02.1976 00:00:00 | 10.04.2017 00:00:00 | 41 | 41 | 41 |
| 467 | 101 | 29.02.1976 00:00:00 | 11.04.2017 00:00:00 | 41 | 41 | 41 |
| 468 | 101 | 29.02.1976 00:00:00 | 12.04.2017 00:00:00 | 41 | 41 | 41 |
| 469 | 101 | 29.02.1976 00:00:00 | 13.04.2017 00:00:00 | 41 | 41 | 41 |
| 470 | 101 | 29.02.1976 00:00:00 | 14.04.2017 00:00:00 | 41 | 41 | 41 |
| 471 | 101 | 29.02.1976 00:00:00 | 15.04.2017 00:00:00 | 41 | 41 | 41 |
| 472 | 101 | 29.02.1976 00:00:00 | 16.04.2017 00:00:00 | 41 | 41 | 41 |
| 473 | 101 | 29.02.1976 00:00:00 | 17.04.2017 00:00:00 | 41 | 41 | 41 |
| 474 | 101 | 29.02.1976 00:00:00 | 18.04.2017 00:00:00 | 41 | 41 | 41 |
| 475 | 101 | 29.02.1976 00:00:00 | 19.04.2017 00:00:00 | 41 | 41 | 41 |
| 476 | 101 | 29.02.1976 00:00:00 | 20.04.2017 00:00:00 | 41 | 41 | 41 |
| 477 | 101 | 29.02.1976 00:00:00 | 21.04.2017 00:00:00 | 41 | 41 | 41 |
| 478 | 101 | 29.02.1976 00:00:00 | 22.04.2017 00:00:00 | 41 | 41 | 41 |
| 479 | 101 | 29.02.1976 00:00:00 | 23.04.2017 00:00:00 | 41 | 41 | 41 |
| 480 | 101 | 29.02.1976 00:00:00 | 24.04.2017 00:00:00 | 41 | 41 | 41 |
| 481 | 101 | 29.02.1976 00:00:00 | 25.04.2017 00:00:00 | 41 | 41 | 41 |
| 482 | 101 | 29.02.1976 00:00:00 | 26.04.2017 00:00:00 | 41 | 41 | 41 |
| 483 | 101 | 29.02.1976 00:00:00 | 27.04.2017 00:00:00 | 41 | 41 | 41 |
| 484 | 101 | 29.02.1976 00:00:00 | 28.04.2017 00:00:00 | 41 | 41 | 41 |
| 485 | 101 | 29.02.1976 00:00:00 | 29.04.2017 00:00:00 | 41 | 41 | 41 |
| 486 | 101 | 29.02.1976 00:00:00 | 30.04.2017 00:00:00 | 41 | 41 | 41 |
+-----+-----+---------------------+---------------------+---------------+--------------+-------------+
So, based on a 2/29 birth date, there is a difference. You contend that use CASE is more accurate?
I have presented requested facts. I believe the case based method to be accurate. I made no statement about any other method.
To go on a total off topic wild goose chase, I found this. According to the US government, and it appears that different countries have different rules, we are all wrong.
So, if you were born on 02/29/1976, you would be 41 on 02/28/2017. This would make the MONTHS_BETWEEN method correct. However, if you were born on 2/28/1976, you would be considered 41 on 02/27/1976, which makes all the methods wrong.
Basically, it seems like nobody can ever be accurate.
A person attains a given age on the day before his corresponding birthday
So, if you were born on 02/29/1976, you would be 41 on 02/28/2017. This would make the MONTHS_BETWEEN method correct. However, if you were born on 2/28/1976, you would be considered 41 on 02/27/1976, which makes all the methods wrong.
Basically, it seems like nobody can ever be accurate.
ASKER
Golden, through and through, great piece of code, nice work, just what I needed, many thanks.
Open in new window
If you can explain the format of the number in the DOB and VISITDATE columns, we can help you get the rest of the information you want.If you provide sample data, in the form of DDL, we can probably give you a working solution.