|
|
Archives of the TeradataForum
Message Posted: Wed, 14 May 2003 @ 16:12:58 GMT
Subj: | | Re: Date Arithmetic |
|
From: | | Dieter N�th |
somya.chaudhary wrote:
| Was wondering if there is a way to also calculate number of months and years between dates. The only answer we get using, e.g.
(current_date - install_dt) is in number of days. Other systems usually have an option of whether the result should be in days, months or
years. | |
As substracting two dates results in an INTERVAL you just have to specify it's kind (V2R3+):
select
(current_date - install_dt) year,
(current_date - install_dt) month,
(current_date - install_dt) year to month
But beware of the default precision of 2 and the maximum of 4, so maximum number of month is 9999.
For details look at the SQL manuals...
Dieter
| |