Archives of the TeradataForum
Message Posted: Fri, 21 Mar 2003 @ 16:32:18 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|