Archives of the TeradataForum
Message Posted: Tue, 01 Aug 2000 @ 14:43:46 GMT
It would appear that V2R2 has a bug regarding the "implicit" conversion of the data types. It is good that it has been fixed in V2R3.
However, I have not ever trusted the implicit CAST and always use the explicit CAST function.
Try the following as I think you will like the results:
sel CAST(99.5 AS decimal(3,0))
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|