Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 26 Aug 2004 @ 17:14:05 GMT


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


Subj:   Re: Overflow error and time(0)
 
From:   Victor Sokovin

  I tried to cast it to 19, but it didn't work in queryman 5.2.  


ODBC driver sometimes treats timestamps differently than BTEQ. For example, TIME(0) in your query would have the data type of INTEGER when returned the ODBC driver. You might try switching off the ODBC extensions in the Queryman options. There might be more details on this in the archives.


  One more question related to this is: How do we extract seconds(0) from timestamp(6). because extract(seconds from time) always gives seconds(6).  


I think you are right about this. Hence the workaround via substrings. BTW, when you mentioned performance difference which queries did you mean exactly?


Regards,

Victor



     
  <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