getting n of days in decimal form

[pooja]

we need to calculate average no of days(in decimal form) between two dates, say ..min date & max date.AND we have db2 as back-end.
please share some advise how to do it

thank you v much in advance

[blom0344]

Cognos has a standard function called:  _days_between to calculate the diff between 2 dates.
Using Cognos functions allows you to stay within Cognos SQL.
For native DB2 functions I would suggest Graeme Birchall's cookbooks as reference:

http://mysite.verizon.net/graeme_birchall/id1.html

Should no be necessary ib this case..

[pooja]

....Should no be necessary ib this case..



??????

[blom0344]

....Should no be necessary ib this case..



??????

" Only use native DB functions when no Cognos equivalent is available"