 |
 |
Archives of the TeradataForum
Message Posted: Mon, 24 May 2004 @ 14:47:24 GMT
| Subj: | | Re: How can I advance a date value? |
| |
| From: | | Dieter Noeth |
Bob Duell wrote:
| | Our database (for whatever reason) has records that are coded '1900-01-01' for that field, so I get an error 7453 (Interval field
overflow). The message text doesn't help me very much, but it looks like there is some precision problem. | |
| | I can't find documentation for the keyword "year" in the expression: | |
Check the SQL manual "Data Types & Literals" for "Date Time & Interval Data".
| | (ASOF_DATE - CONTRACT_DISC_DATE) year | |
| | but playing around with it reveals it is limited to values less that 100 years. Is there any way to change the precision? | |
The default precision is 2 digits, but you can modify it using YEAR(4), this is the maximum precision, 9999 years.
Dieter
| |
