Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 08 Apr 2013 @ 20:07:27 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: 7451 Invalid Timestamp Error
From:   Paul, Aashish


Just wanted to let you all know that I was able to get to the records that were invalid and correct them. Posting what I did so that the next person finds it easier.

As mentioned earlier I had figured that the date part was what was bad and by studying the columns was able to determine that the timestamp was '0000-00-00-'. Somehow Teradata allowed me to add a day to this and still give me a valid timestamp.

     (TS1 + INTERVAL '1' DAY)

So I used a CASE statement to add a day to the field when it is '0000-00-00-' and leave the field as it is when anything else. This solved by 7451 error code.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020