Archives of the TeradataForum
Message Posted: Fri, 06 Mar 2003 @ 21:04:54 GMT
When you are talking about "very large numbers" are you refering to something that wouldn't fit in an integer - such as 1.2e15? The following example generates an overflow - and hence a problem converting the float to an integer:
select 1.2e15 as f, cast (f as integer)
If you are trying to do this, you might need to consider a whole 'nother approach - such as some form of fixed point arithmetic. Could you be more specific as to the problem you are trying to solve? That may lead to a useful solution - especially if you can include some sort of "why you need to go down this path" info as well.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|