Archives of the TeradataForum
Message Posted: Wed, 14 May 2003 @ 16:12:58 GMT
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...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|