FUNCTION TO CONVERT FIELDS TO MONTHS !!

[sereleg]

I will appreciate any help to calculate the fields below into month:
Example:
For productID =1019 How many month are
from 20/4/2005 to 26/05/2005 the result in this case could be 1 and 6 days approximadamente or 1.2 moth

PID FDAY FMONTH FYEAR TDAY TMONTH TYEAR
1019 20 4 2005 26 5 2005
1020 10 11 2004 26 2 2005


Thanks for any help !!

 

[vongrunt]

Probably the best shot is:

select (TYEAR*12 + TMONTH) - (FYEAR*12 + FMONTH) - case when TDAY >= FDAY then 0 else 1 end as MONTHDIFF,
TDAY - FDAY as DAYDIFF
from myTable
order by PID

Note that months have different number of days, so these information have only visual/presentation purpose.

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba