Archives of the TeradataForum
Message Posted: Tue, 13 May 2008 @ 17:00:16 GMT
| Subj: | | Re: Change in casting to Interval |
| |
| From: | | Michael Larkins |
Anomy.Anom wrote:
| | This used to return 7 and after the change it returns 8. | |
> Select ((1080505(date)) - (1000704(date))) year(4);
| | This was really useful to determining the age in years, it�s not anymore. | |
You can use this math to get the old results as above:
Select ((1080505(date)) - (1000704(date)) month(4))/12;
Hope this helps,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| 
