Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 08 Oct 2003 @ 17:41:56 GMT

  <Prev Next>  
Next> Last>>  

Subj:   INSERT/SELECT Problem
From:   Tony Howe

I'm doing an insert select from one table to a new version of the same table with one column added to the end and I getting the following error:

*** Failure 5407 Invalid operation on an ANSI Datetime or Interval value.

Do I have to do some kind of special handling on DATE and TIME columns when inserting from one table to the next? The tables are define exactly the same except the NEW one contains a new column added to the end. I'm lost as to what is causing my error.

What am I missing??


Anthony S. Howe
Teradata Certified Master
Teradata Database Administrator
Highmark, Inc.

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