Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Jan 2008 @ 11:06:28 GMT


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


Subj:   Re: Not a question, but an interesting circumstance
 
From:   Tienhoven, Menno van

Once you've got the glitches figured out, they can be interesting. I agree with you on the first example, but not on the second one.

Direct casting of a timestamp 6 to a zero would implicitly remove precision. I'm glad the system requires you to do so explicitly. But it's not consistent within Tera as the db does implicitly trims leading and trailing spaces. (Not funny with data coming in from Oracle)

But if you're interested: try to get LENGTH (that works fine in queryman) to work in a FastExport script. You would assume all tools of the same vendor would support the same commands, right? Or discover that casting of a date to a certain format only works when you put TRIM around the statement... (my favourite ;-))


Regards,

Menno van Tienhoven



     
  <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