Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Mar 2003 @ 08:14:52 GMT


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


Subj:   Re: Timestamp difference
 
From:   Dieter Nöth

I can't submit the TIMESTAMP(32), it's returning an error 5401: Number of fractional digits out of range. Try a TIMESTAMP(0).

And if it's still doing the CHAR-conversion try different combinations of Options-> Allow use of ODBC SQL extensions in queries and the DateTime Format in ODBC driver Options.

But the easiest way is to submit it using BTEQ, because it's using CLI instead of ODBC.

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