Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 24 May 2004 @ 14:02:18 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: How can I advance a date value?
From:   Duell, Bob

Hi Dieter,

This is a great potential solution! However, I still have one problem: this doesn't work for all values of CONTRACT_DISC_DATE.

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:


but playing around with it reveals it is limited to values less that 100 years. Is there any way to change the precision?


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019