Archives of the TeradataForum
Message Posted: Fri, 21 Mar 2003 @ 16:59:51 GMT
Actually, it does work in V2R4; but the 5407 error doesn't tell you much. The trick is that Teradata requires you to explicitly specify the precision of the resulting interval, e.g
SELECT TimeStamp2 - TimeStamp1 DAY(4) TO SECOND(6) ...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|