 |
 |
Archives of the TeradataForum
Message Posted: Wed, 23 Jul 2008 @ 13:01:40 GMT
| Subj: | | Re: How to Achieve the decimal part |
| |
| From: | | Victor Sokovin |
| | In Oracle MONTHS_BETWEN() will give result in fractions like xx.yyyy I am trying to calculate months between two dates in teradata but I
unable get the fraction value i.e simply its giving xx but can we get the result in fractions in TD . | |
| | I can get the months in days and we can divide it with 30 we will get some approximate value but its not accurate. | |
Try 31.
Victor
| |
