Archives of the TeradataForum

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

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

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??

Thanks,

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

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