Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Mar 2013 @ 20:49:38 GMT


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


Subj:   Re: 7451 Invalid Timestamp Error
 
From:   Pluebell, Fred

I'm guessing this is TD13.10 or later, on a system where local time zone is in effect, and the time zone adjustment between internal and external formats is causing the error. Try something like this to see the offending values and understand the issue:

     CAST(TS2 AS TIMESTAMP(6) WITH TIME ZONE AT TIME ZONE 0)


     
  <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