Archives of the TeradataForum

Message Posted: Tue, 14 Sep 2004 @ 13:35:41 GMT

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

It would appear that Teradata and SQL Server use different rules for implicit conversion of unmatched values before a mathematical operation.

As you have discovered you get the same result (to 13 decimal places) when you explicitly specify the data type conversion.

     SELECT 6*393.2600*1.57000*(CAST(10 AS FLOAT)/60.00)

     retuns
       Teradata    617.418200000
       SQL Server  617.41819999999996
       Calculator  617.4182

It is generally recommended that you specify the data type you require if there is any doubt/ambiguity in what the system may do.

Mike Dempsey
Teradata Client Tools

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