I want to find the number of days between one date and another. DB2 can subtract dates and it gives me:
YYMMDD
I'd like to convert this to a number of days using (yy*365) + (mm*31) + dd. Unfortunately, the MM component seems to be a variable number of days depending on how long each month is (31 days, 30 days etc). It looks like that to get the number of days I'd have to go through some horrendous process of comparing the two dates and working out which months lie between them so that I can assign the correct number of days. Is there any way you can just get an absolute number of days between two dates ?
YYMMDD
I'd like to convert this to a number of days using (yy*365) + (mm*31) + dd. Unfortunately, the MM component seems to be a variable number of days depending on how long each month is (31 days, 30 days etc). It looks like that to get the number of days I'd have to go through some horrendous process of comparing the two dates and working out which months lie between them so that I can assign the correct number of days. Is there any way you can just get an absolute number of days between two dates ?