Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 24 May 2004 @ 14:47:24 GMT


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


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



     
  <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: 27 Dec 2016