Archives of the TeradataForum

Message Posted: Fri, 21 Mar 2003 @ 16:32:18 GMT

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

The ANSI SQL standard (ISO/IEC 9075-2:1999, sec. 4.7.3, p. 29) defines six operations on timestamps and intervals. Under V2R4, all of these are supported except one: a timestamp minus a timestamp should yield an interval. Instead, it gives error 5407, "Invalid operation on an ANSI Datetime or Interval value". Does anyone know whether this is supported in V2R5?

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