 |
 |
Archives of the TeradataForum
Message Posted: Mon, 05 Sep 2005 @ 13:54:55 GMT
| Subj: | | Re: INTERVAL math and error 7453 |
| |
| From: | | Bach, Michael |
| | From what I remember 9999 is the largest value for any interval. | |
| | From here on in , you need to use combinations of intervals as you've already done to receive an answer without overflow | |
Not too sure what intervals exist in SQL for your purpose
Month to day does not exist ?
Year to month does
Regards
Michael Bach,
AM Common Services
Group Data Warehouse - Service Continuity DBA
| |
