Archives of the TeradataForum
Message Posted: Wed, 08 Oct 2003 @ 17:41:56 GMT
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
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023