Archives of the TeradataForum

Message Posted: Thu, 28 May 2009 @ 09:16:43 GMT

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

Hi,

Am trying to create a VIEW by selecting from table with one of the VIEW attributes being "timestamp_1 minus timestamp_2". This resulted in error:

Invalid operation on an ANSI Datetime or Interval value

The same SELECT statement is used...instead of creating a VIEW, I created a TABLE instead. That worked. Could someone please tell me how to workaround so that I can create the view?

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