Archives of the TeradataForum
Message Posted: Thu, 28 May 2009 @ 09:16:43 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|